N
News Starstream
I just upgraded from Access 2003 to 2007 and one function doesn't work
anymore. I had one field where I entered date of purchase and another field
that was calculated by current date. It was entered in the Expression
Builder
=Date() - [date purchased]
(Date purchased is the name of the field where I enter date article was
purchased.)
This would give me the age of the article in my household inventory. Now it
gives me a value that has "19" in front of the actual age of the article.
e.g. instead of 36 years old, it gives me 1936 years old. In the property
sheet, I have the Format set at yy to give me two place setting for the
calculated result.
How do I get things working right again?
Neil
anymore. I had one field where I entered date of purchase and another field
that was calculated by current date. It was entered in the Expression
Builder
=Date() - [date purchased]
(Date purchased is the name of the field where I enter date article was
purchased.)
This would give me the age of the article in my household inventory. Now it
gives me a value that has "19" in front of the actual age of the article.
e.g. instead of 36 years old, it gives me 1936 years old. In the property
sheet, I have the Format set at yy to give me two place setting for the
calculated result.
How do I get things working right again?
Neil