date function

[Newbie]

Hi,

I want to be able to set a datepicker to a default date of
the monthend date 2months before the current month

I have tried
mDate = DateSerial(Year(date),Month(date) - 2, Day(0))

but this gives me

when Date = 17/11/03

mDate = 30/9/03

when Date = 17/12/03

mDate = 30/10/03 = . . . this should be 31/10/03

What am I doing wrong?

 

[Dan Artuso]

Hi,
I beleive this will do the trick:
DateSerial(Year(date),Month(Date)- 1, 0)

 

[Newbie]

Thanks - works a treat

Hi,
I beleive this will do the trick:
DateSerial(Year(date),Month(Date)- 1, 0)