Trying to "do the math" - getting nowhere fast.
<cfset FirstDayOfQuarter = ?>
<cfset LastDayOfQuarter = #CreateODBCDate(Now())#>
WHERE ((order_create_date BETWEEN #CreateODBCDate(FirstDayOfQuarter)# AND #CreateODBCDate(LastDayOfQuarter)#))
I'm sure there is more than one way to accomplish this, and CF has #Quarter(Now())# but that result just dispalys what quarter you happen to be in now.
Any help would be appreciated.....
We have a very useful table in our data warehouse called period. The primary key is the date and other fields include fiscal year, fiscal quarter, fiscal period, holiday, and a few more. You might want to consider something similar.