Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for 
Search instead for 
Did you mean: 
lu2021
Contributor II
Contributor II

sysdate

how do I write this in Qlik sense

DATE BETWEEN SYSDATE - 60 AND SYSDATE

1 Solution

Accepted Solutions
yilmazmurat
Contributor III
Contributor III

You can try the expression below.

 

IF(Your_Date_Field<DATE(NOW()) AND Your_Date_Field>DATE(NOW()-60),1,0)

View solution in original post

1 Reply
yilmazmurat
Contributor III
Contributor III

You can try the expression below.

 

IF(Your_Date_Field<DATE(NOW()) AND Your_Date_Field>DATE(NOW()-60),1,0)