Make month list last day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box that shows the end of the Month. It says "May 2005". I
want a text box to show the last day of the month. How can this be done?
 
How are you getting the existing value? Do you have a field that it's based
on? If you've got a value dtmWhatDate, you can figure out the last day of
that month as DateSerial(Year(dtmWhatDate), Month(dtmWhatDate) + 1, 0)
 
Back
Top