date changes

  • Thread starter Thread starter ghostmiro
  • Start date Start date
G

ghostmiro

i have an datefield where an startdate is introduced for exampl
05/06/2004.

Now i want another field where the last day of that month i
presented?
how can i do that?

thx in advance

miro

:confused
 
Last day of the month can be calculated as DateSerial(Year([StartDate],
Month([StartDate]) + 1, 0)
 
Thank you verry much Douglas J. Steele!

Your a lifesaver;)

I you give me your adres i send you a good belgium beer
 
Back
Top