end of month

[Guest]

I am trying to return the end of the month from any given date.

e.g. 22/06/2005 would return 30/06/2005

Does anyone know how in a query this can be done ?

 

[Van T. Dinh]

DateSerial(Year([YourDate]), Month([YourDate]) + 1, 0)

will give the end of the month correspond to [YourDate].