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)

 

[jfp]

subtract one from the first day of the current month.
-=-=

 

[Newbie]

thanks - works a treat

Al

You might try an expression like:

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