Get Previous 6 Months

[JaB]

Hi All

I have searched for a solution to this for quite some time but have yet to find one, I'm sure it's quite a basic solution in reality.

Basically, I have an ASP reporting script which I would like to query MSSQL to grab data based on the last six months, I have coded the SQL already but I simply need to pass it a @FromDate and a @toDate for each month.

Is is possible in asp to generate these for the last 6 months.. e.g.

01-01-2007 - 01-31-2007
02-01-2007 - 02-28-2007
etc.. etc..

Thanks in advance for any help!

John

[padmakar]

As far as i know asp doesnt have any function to do this automatically..what you can do is pass the day,month and year through intermediate function before you can pass @fromdate,@todate.
GetDateForMonth(ByVal Month As Integer, ByVal Day As Integer)
Select Case Month
Case 2 : If Day > 28 Then Day = 28
Case 9, 4, 6, 11 : If Day > 30 Then Day = 30
End Select

same for the year as well if month=1 then year-1
this should solve your problem