FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC:

How do I filter on dates greater than 01/01/2020 1 month 3 weeks ago #3670

  • Ken Starnes
  • Ken Starnes's Avatar Topic Author
  • Offline
  • Posts: 10
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

Please Log in or Create an account to join the conversation.

How do I filter on dates greater than 01/01/2020 1 month 3 weeks ago #3671

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.

 

 

File Attachment:

File Name: date-filte...tion.zip
File Size:6 KB
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:

Please Log in or Create an account to join the conversation.

How do I filter on dates greater than 01/01/2020 1 month 3 weeks ago #3672

  • Ken Starnes
  • Ken Starnes's Avatar Topic Author
  • Offline
  • Posts: 10
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.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.163 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2022 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en