1st and last day of month 1

[GShen]

Is there an easy way (function) other than creating a long string with datepart to get the 1st and last day of a prior month ? Assuming this job runs the 1st day of every month.
Ex. 3/1/10, I need a start date of 02/01/10 and an end date of 02/28/10.
Ex. 01/01/10, I need a start date of 12/1/09 and an end date of 12/31/09.

I am doing a long string manipulation to get this, just wondering if there were any reserved words to pick this off more efficiently.



Remember when... everything worked and there was a reason for it?

 

[r937]

if you are certain that the job will always run on the first day of the month, then DATEADD(m,-1,GETDATE()) will give you the first day of the previous month, and DATEADD(d,-1,GETDATE()) will give you the last day of the previous month, with both expressions safe for use across year boundaries

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[markros]

Yes, simple enough

See

http://wiki.lessthandot.com/index.php/How_to_find_the_first_and_last_days_in_years,_months_etc

PluralSight Learning Library

 

[GShen]

r937,
Thanks! I thought I did something like this somewhere and I couldn't and still can't find it. This will work perfectly. Yes, it is in a job scheduled to be run on the 1st day of every month.
Much easier to read than the nonsense I was creating.

Remember when... everything worked and there was a reason for it?

 

[djj55]

Look at the FAQ section for this forum

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!