Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date filter

Hi,

I have data with date formatted dd/mm/yyyy

I would like to create a filter pane for date before a certain date month and year, like records before 12/11/1993

IF ( DATE < 12/11/1993,1,0)

Is that how it works?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=If(Date < Date#('12/11/1993','DD/MM/YYYY'),1,0)

or

=If(Date < Date#('12/11/1993','DD/MM/YYYY'),Date)

View solution in original post

2 Replies
MK_QSL
MVP
MVP

=If(Date < Date#('12/11/1993','DD/MM/YYYY'),1,0)

or

=If(Date < Date#('12/11/1993','DD/MM/YYYY'),Date)

susovan
Partner - Specialist
Partner - Specialist

Hi,

You can also try this below expression.

Expression:

if(StartDate<'2016-02-27',1,0)

Warm Regards,
Susovan