Calculate Last Day of Previous Month 1

[spiff2002]

I'm working on MS-SQL 2000 and I'm trying to calculate the last day of the previous month, i.e.:
Today's date is 12/10/2003 after running the query using today's day as parameter I will get

11/30/2003

Is there a MS-SQL 2000 functions that can do this or has to be calculated with a whole bunch of case statements??

 

[bdreed35]

This should get you what you want:

select DateAdd(d,-Day(getdate()),getdate())

~Brian

 

[spiff2002]

Thanks a lot!!!

 

[JustATheory]

Has anyone had any luck using the end of month function in an access query. I tried:

eomonth(date(),-1)

I'm getting an undefined function.

Any help would be great.

Thanks!

 

[PHV]

Have you tried this ?
DateSerial(Year(Date()),1+Month(Date()),0)

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JustATheory]

Perfect!

Thank you,
Andy