cdate(cstr(month(currentdate)) + "/1/" + cstr(year(currentdate)))
First day of Current Month in the Current Year.
it's 05/06/2008
I want 05/01/2008
Thanks for any help.
Printable View
cdate(cstr(month(currentdate)) + "/1/" + cstr(year(currentdate)))
First day of Current Month in the Current Year.
it's 05/06/2008
I want 05/01/2008
Thanks for any help.
sorry,
cdate(year(currentdate), (month(currentdate)), 1)
took me 25 minutes to get that right though.