First/Last Day of the Month 1

[pvwdr]

Given a date, 2/5/03, how can I quickly determine the first and last day of the month.

If given 2/5/03, I need to get 2/1/03 and 2/28/03.
The only way I can figure to do it is tear the string apart and do a series of IF statements ... are there any functions that give those dates based on any date given?

Thanks,
Bill

 

[MichaelRed]

? dateSerial(Year(Date), Month(Date), 1)
2/1/03
? dateSerial(Year(Date), Month(Date) + 1, 0)
2/28/03

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[pvwdr]

Dude, you kick ass ... thanks

 

[MichaelRed]

Searching for employment in all the wrong places


MichaelRed
m.red@att.net

Searching for employment in all the wrong places