Sage 100

Access 2003

SELECT IM_Audit.Date, IM_Audit.WorkstationName, IM_Audit.ItemCode, IM_Audit.ItemCodeDesc, IM_Audit.TransactionType, IM_Audit.FieldName, IM_Audit.FieldValueOriginal, IM_Audit.NewFieldValue
FROM IM_Audit
WHERE (((IM_Audit.Date)=#1/10/2018#) AND ((IM_Audit.WorkstationName)="SJ-DE-100"));

The above date value doesn't work, But {d '2018-01-10'} doesn't work either.

Who has a working query into the Providex backend DB using date criteria? Would love to know.

Also, could it be Access 2003??