Append query returns message: "undefined function "Date" in expression

Question

I am updating my Access 2000 to Access 2016.  My access 2000 has a query to append data including two dates defined as "Date()" for the current date.  I am appending data from one data base to another one.   When I run this query in Access 2016 it returns a message: " Undefined function 'Date' in expression."  Is the Date() function from Access 2000 not supported in Access 2016?

Here is the SQL:  

INSERT INTO Expenses ( [Addr Code], Vendor, [Expense Code], Amt, [Inv Date], [Date Entered] ) IN '\\guy\access\db1.mdb'

SELECT "XSM" AS [Addr Code], "FICAme" AS Vendor, "Tax" AS [Expense Code], [FICAme Total].SumOfFICAme, Date() AS [Inv Date], Date() AS [Date Entered]

FROM [FICAme Total];

Thank you for your help,

Guy

Answer 1

Hi Guy, Date() is still supported; however, broken references due to newer versions of Access break some internal functions. Check your VBA references and fix any missing ones. Hope it helps...

Answer 2

You might try Now() instead of Date().

Answer 3

I agree with theDBguy this sounds like a classic case of broken VBA references.

Go into the VBA Editor (VBE) and Under Tools select References... then examine the list and look for any where it is specified MISSING. You need to remove/replace those reference libraries. Always ensure your VBA project compiles without any errors and then try you query again.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 4

Hi gsdevel,

Has your original issue been resolved? If it has, I would suggest you mark the helpful reply as answer or provide your solution and mark as answer to close this thread. If not, please feel free to let us know your current issue.

Best Regards,

Terry