My query used to have this: DaysUntilExpire: [Expires]-Date()
"Expires" was a field from the table, but "date()" would grab the current date. This worked in access 2003 and 2007. However in 2010, they do not allow this to grab the date anymore...
I checked all over online and most references say to use a datepicker now.. but the datepicker would be used in a form, but im using a query.. I can not find anywhere to figure out how to calculate the current date within a query... (access 2010)...
Does anyone know how to do this now?
*FYI... in older versions, you could just use the following: =date()
but now that does not work.
Make the concept of date since a variable and pass it in as a parameter.
This topic is now archived. It is frozen and cannot be changed in any way.