sysdate

[lu2021]

how do I write this in Qlik sense

DATE BETWEEN SYSDATE - 60 AND SYSDATE

[yilmazmurat · Accepted solution]

You can try the expression below.

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