DatePart Question

E

ETSherman

Is there a function to change or modify a date "04/26/04" to the Month End
date "04/30/04" for the Month part of the original date.

In other words, change the date to the Month End date of the Month Part.

Thanks,

ET
 
D

Douglas J. Steele

If you've got a date dtmMyDate, you can get the last day of that month using

DateSerial(Year(dtmMyDate), Month(dtmMyDate) + 1, 0)
 
Top