Question Locked
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 suzanne.parker Accepted solution
Clarifications
by tony hopkinson Accepted solution
Date() returns today's date.
If you want a SQL compliant version then it's GetDate()
by suzanne.parker Accepted solution
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 Accepted solution
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.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies