Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
May be -
WHERE Date(Floor("SERVICE DATE")) >= MakeDate(2017,01,01) and Date(Floor("SERVICE DATE")) <= MakeDate(2017,12,31)
Sorry the delayed response, it worked.
Hey I am getting an error message and not sure why. I am trying to filter out my invoice date to only show 2018 data but I keep getting an error message. Here is my script:
[SALES_USAGE_HDR]:SELECT "BRANCH_NAME","INVOICE_DATE","NATL_ACCT_NO","CUST_PO_NO"FROM "WHSE"."SALES_USAGE_HDR";WHERE INVOICE_DATE >= MakeDate(2018,01,01) AND INVOICE_DATE <= MakeDate(2018,12,31);
It worked thanks!