Question Locked

Access - Calculation of current date minus two other date fields

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm learning this on the fly and trying to create an expression in Access of a sum of today's date-[date1]-[date2] but can't figure out how to put today's date into an expression. Any help would be appreciated.

4 replies

by tony hopkinson

Date() returns today's date.

If you want a SQL compliant version then it's GetDate()

by suzanne.parker

After searching my books and the internet for two days and before I saw your post, I tried this and it worked.
Expr1: DateDiff("d",Date(),[FIELD1],[FIELD2])
Thanks for your help.

by suzanne.parker

After searching my books and the internet for two days and before I saw your post, I tried this and it worked.
Expr1: DateDiff("d",Date(),[FIELD1],[FIELD2])
Thanks for your help Tony.

This discussion is closed to new replies.