DatePart Question

[Guest]

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

 

[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)