The easiest way I know:

lcDate=GoMonth(ldMyDate-day(ldMyDate),1)

This doesn't depend on SET CENTURY or SET DATE, it works for leap years, etc.

Vlad

>Base on a specific date, is there a function which will return the last date of the month?
>
>For example, I have 01/01/1997, I would like to have 31/01/1997.