Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Fig1
Contributor III
Contributor III

WHERE CLAUSE - DATE ONLY (FROM DATETIME FIELD)

WHERE

ORDER_DATE>={ts '2020-07-01 00:00:00'} AND
ORDER_DATE<={ts '2021-05-31 23:59:59'}AND
ORDER_DATE <> ADMIT_DATE  // I need  this to be : date(order_date) <> date (ADMIT_DATE)

WHAT SYNTAX/FORMAT DO I USE TO PULL THE DATE ONLY FROM THESE TWO FIELDS??

0 Replies