Determine last day of the month 1

[lhrpa]

I would like to be able to compare a date within my data to the last day of the previous month, is there a last day function of some sort in SQL Server?

Thanks for any guidance!

Linda

 

[dinzana]

How about this,

select dateadd(d,-day(<date_column_name>),dateadd(m,1,<date_column_name>)) as lastdayofmonth from <table_name>

Hope that this helps.

-dinzana

 

[dinzana]

Check this thread, there are some other solutions, also.

Take care,

dinzana

thread183-459528

 

[lhrpa]

Thanks, that's perfect! I'll also check out the other thread. Thanks a lot for your help,

Linda