Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=If(Date < Date#('12/11/1993','DD/MM/YYYY'),1,0)
or
=If(Date < Date#('12/11/1993','DD/MM/YYYY'),Date)
=If(Date < Date#('12/11/1993','DD/MM/YYYY'),1,0)
or
=If(Date < Date#('12/11/1993','DD/MM/YYYY'),Date)
Hi,
You can also try this below expression.
Expression:
if(StartDate<'2016-02-27',1,0)