Last Month Date Range CFSET

[3dColor]

I currently track a parameter from the first of the year and the first of the current month.

But I would also like to track all of last month.

Here is what I have so far that works - in the WHERE statement of the query.

<cfset today = CreateODBCDate(Now())>
<CFSET tektips = CreateDateTime(year(today), 1, 1, 0, 0, 0)>
<CFSET sinceThe1st = CreateDateTime(year(today), month(today), Day(tektips), hour(tektips), minute(tektips), second(tektips))>
<CFSET sinceThe1stOfTheYear = CreateDateTime(year(today), month(tektips), Day(tektips), hour(tektips), minute(tektips), second(tektips))>

How do I do one for last month with is a moving target?

 

[cfSearching]

Read up on the DateAdd function. Since you already have the first day of the current month, you can use it to determine the other values. To get the first of the previous month, just subtract one month.

<cfset firstOfPreviousMonth = dateAdd("m", -1, firstOfThisMonth)>

To get the last day of the previous month, subtract one day.

<cfset lastOfPreviousMonth = dateAdd("d", -1, firstOfThisMonth)>

http://livedocs.adobe.com/coldfusion/8/functions_c-d_25.html

----------------------------------

http://cfsearching.blogspot.com/

 

[3dColor]

Thanks!