What is the syntax I would use to filter for dates in my data Load?
Date(Floor("SERVICE DATE")) as "Date",
Units as UNITS,
FROM [lib://ENTERPRISE/PATIENT LEDGER.xlsx]
(ooxml, embedded labels, table is [Charge Pivot])
WHERE "SERVICE DATE" BETWEEN '01-01-2017 and '12-31-2017'
Thanks in advance.