change a date to the end of the month

[Jerry Crosby]

How do I convert a given date to the last day of the same month, taking into
consideration that the last day of the month varies by month. I'm willing
to disregard leap year.

Example: 10/3/05 becomes 10/31/05.

Thanks in advance.

Jerry

 

[Duane Hookom]

Try:
DateSerial(Year([DateExpression]), Month([DateExpression])+1, 0)