I am entering a criteria in a query in MS Access 2010.
The expression is as shown below:
>#Date()# and <#Exp_Date#
where Date() is current date
and
Exp_Date is the expiration date.
In other words I am trying to find all licenses that have not expired. Their Exp_Date is greater than today current date.
MS access 2010 says that the expressions contains in incorrect date value,;I have defined them as you see..
What am I doing wrong?
Any help appreciated. Thanks in advance.
Respectfully,
Lou_Reed
The