Why not use a -1 from the 1st of the month? DATE(2011,3,1) - 1 returns 2/28/11
>>We know that February's numbers of days varies from 28 to 29 depending on if the year is a leap year.If you want to get the ending date of a month and don't want to deal with determining the leap year, how would you do this?
>>
>>Cecil
>
>Also if you test these, 2011 will give you an empty date, but 2012 will not
>
? date(2011,2,29)
>? date(2012,2,29)