C
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.
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.