How do I filter on dates greater than 01/01/2020

I've tried creating an If heater with filter with a Date field >= 01/01/2020 but it outputs a 'no'  rather than the date

I know it's very simple for those who know.

Havent found any examples here. Data is not sorted by Date however

Hi Ken,

You have to use the Filter Heater in combination with the IF-THEN-ELSE Heater for the condition.
Move both Heater/Functions onto the designer. Connect your desired data field to the IF-THEN-ELSE Heater and connect the output from this Heater to the Filter Heater .

Now you have to define the filter condition. Open the IF-THEN-ELSE Heater configuration, activate the option “Changing data types” and choice “Date”. Below you have to select “>=” and insert your condition value like “01/01/2020”. Here you have to use the same format like defined into the Write Adapter, see screenshot below.

Please have a look to the attached example.

 

 

Thanks Robert - that was what I was trying to do. What I hadn't done was add the Changing Data Type to DATE - makes sense now.
Doh.