Question

Locked

Access - Calculation of current date minus two other date fields

By suzanne.parker ·
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.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

In access

by Tony Hopkinson In reply to Access - Calculation of c ...

Date() returns today's date.

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

Collapse -

Access Date calculation

by suzanne.parker In reply to In access

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.

Collapse -

Access date calculation

by suzanne.parker In reply to Access - Calculation of c ...

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.

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums