Date issue dont know how it will work

[ThaiByThai]

Hello -

I have a query appending to a table called tblCompDate

In the query I would like my tblCompDate to show me a column called Date_Report and in the Date_Report column I would like it to use Completion_date PLUS 10years THEN minus 6Months to be the output of the date.


so for example :

completetion_date is 2/1/2002 add 10yrs to that date THEN minus 6months from that date.

So

Complettion_date = 2/1/2002
10Yrs_date = 2/1/2012
Minus 6month = FINAL date= 7/1/2012

 

[boblarson]

It would be like this in the grid:

FinalDateateAdd("m", -6, DateAdd("yyyy", 10, [Completion_date]))

 

[ThaiByThai]

hi boblarson

First off THANK YOU for the quick respond!

when i enter the information in my "criteria" i am getting an error message "The experssion you entered has a vaalid. (dot) or ! operator or invalid parenthese. You may have entered an invalid identifier or typed parentheses follwing the NULL constant"


I'm using access 2007 is there something else i have to do?

 

[ThaiByThai]

BTW - sorry if i am asking a stupid question... i am a NEWBIE at access...

 

[boblarson]

hi boblarson

First off THANK YOU for the quick respond!

when i enter the information in my "criteria" i am getting an error message "The experssion you entered has a vaalid. (dot) or ! operator or invalid parenthese. You may have entered an invalid identifier or typed parentheses follwing the NULL constant"


I'm using access 2007 is there something else i have to do?

The item I gave you does NOT go in the Criteria area. It goes in the FIELD area of the grid as its own new field. Hence the new name:
FinalDate and then the colon.

 

[DCrake]

Where abouts are you using this calculation?