Access 2016

Copper Contributor

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 Replies

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

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