I have a linked SQL Server table into my access database. the field is called saleDT and it is a date time field. What would the syntax of my query be in my access query to return all records for todays date? I tried the below but it returned 0 results
Code:Select saleDT, * FROM importedData Where SimportDT = Date()