Forum Discussion

Arun_Kumar's avatar
Arun_Kumar
Copper Contributor
Sep 23, 2019

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 ver...
Access Web Database
Siriah's avatar
Siriah
Copper Contributor
Sep 29, 2019

Arun_Kumar I believe the best way to guarantee dates show up is to use <, >=, instead of Between or AND.

Resources