How to calculate Date?

[neomorpheus]

I need to find the date that was two months back from current date (today). It also needs to keep in mind 30 or 31 days in a month.

I thought about calculating it by subtracting 60 days, but it doesnt give me an exact/ correct date. Since the data I am going to display is time-specific, i need it to be absolutely correct.

Please help.... suggestions welcome.

Thanks

 

[r937]

let's say the current date is april 29, 2003

which date would you like the function to return?

also, do you want to use this date in a database query? if so, you may be better off using a database function than a coldfusion function


rudy

 

[bhightower]

<cfset todaysDate = now()>
<cfset lastMonthsDate = dateAdd(&quot;m&quot;, -1, todaysDate)>
<cfset date2MonthsAgo = dateAdd(&quot;m&quot;, -2, todaysDate)>

and if you want to use this date in a query then just use

createODBCDate(lastMonthDate) ------------------------------------------------------------------------------
brannonH
if( !succeed ) try( );

 

[r937]

good one, brannon, but did you notice that april 29 and april 30 both yield the same date, feb 28?

that's only &quot;absolutely correct&quot; if you allow it

 

[csteinhilber]

Sounds like that's what he wanted, since he said subtracting 60 days wasn't giving him the correct date. Why can't all months just have 30 days, and be done with it ;-)


-Carl

 

[r937]

there'd be riots in the street

http://google.com/search?q=

GIVE+US+BACK+OUR+ELEVEN+DAYS

more calendar links on my site:

http://rudy.ca/callinks.html

 

[neomorpheus]

Heeding to the advic eon one of the posts, I did it using a databse function-

****************************************************
CREATE PROCEDURE [GetDateRange] AS
DECLARE @date DATETIME,
@fdate DATETIME,
@ldate DATETIME

SELECT @date = Getdate()
SELECT @ldate = @date

--For the months Jan and Feb, we hardcode to prevent
--negative values

If datepart( mm, @date) = 1
Begin
SELECT @fdate = '11/' + Convert(varchar(2),datepart( dd, @date)) + '/' + Convert(varchar(4),datepart( yyyy, @date))
End
--
If datepart( mm, @date) = 2
Begin
SELECT @fdate = '12/' + Convert(varchar(2),datepart( dd, @date)) + '/' + Convert(varchar(4),datepart( yyyy, @date))
End

-- For month grater than Feb, use the formula below

If datepart( mm, @date) > 2
Begin
SELECT @fdate = Convert(varchar(2),(datepart( mm, @date)-2)) + '/' + Convert(varchar(2),datepart( dd, @date)) + '/' + Convert(varchar(4),datepart( yyyy, @date))
End

--
SELECT 'FirstDay' = @fdate,
'LastDay' = @ldate

***********************************************************

Thanks for your feedback.