Forum Discussion
Access 2016
Hi whenever i am writing criteria while creating query 'Between Date() and Date() +30' getting message 'Undefined function in the expression' in access 2016. However same is taken by access 2007 version. Kindly advice.
''
- I think you will be OK if you add parenthesis around the second Date() and the +30. Like Between Date() and (Date() +30)
Arun_Kumar I believe the best way to guarantee dates show up is to use <, >=, instead of Between or AND.
