Access 2016

[Arun_Kumar]

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.

''  

[#2]

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

[#3]

I think you will be OK if you add parenthesis around the second Date() and the +30. Like Between Date() and (Date() +30)