>>Hello everyone.
>>
>>Is there a native VFP function to return the last day of the month?
>>
>>Thanks,
>>Sergio
>
>Not that I know of, but you can use the DATE() function. For example, if you wanted to know the last day of the current month, you could do something like this:
>
>DATE(YEAR(DATE()), MONTH(GOMONTH(DATE(), 1)), 1) - 1
>
>hth
That won't work for dates in December because it will give you 31-Dec-1998.
You could add the following:
DATE(YEAR(DATE()) + IIF(MONTH(DATE()) < 12, 0,1) , MONTH(GOMONTH(DATE(), 1)), 1) - 1
to it. Or you could use my method. (See Message)
-cjh