Calculate month ending date

[CAM]

Hello,

I am trying to figure this out. I have a field call "Completed" a date
field (10/21/2006) want I want to do is to somehow calculate the month
ending date based on the "Completed" field to a field call "Month Ending"
For example:

Completed
9/1/2006

Month Ending
9/30/2006

or

Completed
10/19/2006

Month Ending
10/31/2006


or

Completed
1/4/2007

Month Ending
1/31/2007

How can I do this in a query. Any tips or web site to visit will be
appreciated thank you in advance.

 

[Duane Hookom]

You can use:
MonthEnding: DateSerial(Year(Completed),Month(Completed)+1,0)