>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
Doug Stalter
"According to the proverb, the best things are the most difficult." -Plutarch