In SQL I think it's GetDate() vs. Date() in Access.
Either way it doesn't seem like it's the correct syntax in SQL
Would love to be able to use your formula in a SQL View / Query.
Competent Performer
Windows 7 32bit 
Access 2013
In SQL I think it's GetDate() vs. Date() in Access.
Either way it doesn't seem like it's the correct syntax in SQL
Would love to be able to use your formula in a SQL View / Query.
VIP
Windows 7 64bit Access 2010 32bit
The expression works for me.
Are you using the query builder?
If you want to provide db for analysis ...
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 32bit Access 2013
So that formula works in SQL?
I'm in a View and I get the invalid message
VIP
Windows 7 64bit Access 2010 32bit
Sorry, don't know SQLServer, don't know what a View is.
The expression works in an Access query.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Parameter Box Date Range
Posting Permissions
Reply With Quote