end of month

W

whitey

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 ?
 
V

Van T. Dinh

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

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