find out end date of next month.

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I have a field named dateinvoice that currently
has the following value = #03/06/2004#.
varDateBeg needs to contain the beginning of the
invoice date which is #03/01/2004#.
I was able to get this date by using DateSerial.

varDateBeg = DateSerial(Year([dateinvoice]), Month
([dateinvoice]), 1)

However now I need to be able to determine the last date
of the next month (April) which should give me
#04/30/2004#. How can I obtain/retrieve this date?
TIA.
 
Back
Top