date prob

[ghostmiro]

Hi guys,

I have a little problem, how can i change an date f.e. 05/02/2004
that he gives me the last day of that month?

Thx in advanc

 

[Douglas J. Steele]

DateSerial(Year(MyDate), Month(MyDate) + 1, 0)