dateadd . . . .again

[Newbie]

Hi
how can I always return the last day of the month preceding the month that
we are currently in?

i.e for any date in September I want to be able to return 31/8/2003

 

[Brian Camire]

You might try an expression like:

DateSerial(Year(Date()),Month(Date()),0)