I have a script that allows users to select a date range of :
I need to know how to write the query to create a start and end date for each selection above.
Is it possible to do in a query or would you need to do it in say Coldfusion first then use a variable??
I can accept a coldfusion answer or straight sql.
God Bless ALL..
<cfquery datasource = "#mydsn#" name = "myQ">
Select * from mytable
where date between ........ and .......