Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: selecting records in date range

selecting records in date range 1 year 10 months ago #2344

  • Andrew Wojciak
  • Andrew Wojciak's Avatar
  • Offline
  • Junior Member
  • Posts: 21
Hi,
I have pipe delimited .txt file where dates are in ISO format YYYY-MM-DD.
In .txt output (WRITE) I want only records with dates = TODAY - 7 + 30 days. TODAY must auto-change daily. Does someone know how to do it easily? Sample file is attached.
Thank you,
AW
Attachments:
The administrator has disabled public write access.

selecting records in date range 1 year 10 months ago #2345

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Andrew,

You need the power of flexible Parameters :)

First you have to define your Filter condition. For this we need two Parameters $MINDATE$ and $MAXDATE$. These Parameters can be set with the Set Parameter Heater. The current Date retrieved the Now Heater. This value you have to modify with the DateAdd Heater, one time +30 days and one time -7 days. Nevertheless you have to set this values to an ISO Date. This can be done with the String Format Heater.

Now we got two dynamical Parameters $MINDATE$ and $MAXDATE. This we just have to add into an IF-THEN-ELSE condition to filter the not needed CSV records.

I’ve made a simple example, please have a look to the attachment.

CSV date range filter condition


CSV ISO date format 1


CSV ISO date format 2


File Attachment:

File Name: csv-date-r...tion.zip
File Size:3 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.
Last Edit: 1 year 10 months ago by FlowHeater-Team.
The administrator has disabled public write access.

selecting records in date range 1 year 10 months ago #2346

  • Andrew Wojciak
  • Andrew Wojciak's Avatar
  • Offline
  • Junior Member
  • Posts: 21
Thank you, Robert.
Great solution and works perfectly.
AW
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.086 seconds