how to get the last day of the month with a date 1

[Guest_imported]

I want get the last day of the month with a date in a query.
How to do ?
For example, the date is ¡°2001/10/15¡± , the month is ¡°10¡±, the last day is ¡°31¡±, is there a function that calculated the end day?

 

[THoey]

if you do a keyword search on "last" and "month" you will find this thread:

thread181-61889

Terry M. Hoey

 

[Guest_imported]

thank for you!