- Posts: 21
selecting records in date range
- Andrew Wojciak
- Topic Author
- Offline
- User
Less
More
9 years 9 months ago #2344
by Andrew Wojciak
selecting records in date range was created by Andrew Wojciak
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
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:
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
9 years 9 months ago - 9 years 9 months ago #2345
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic selecting records in date range
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
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
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: 9 years 9 months ago by FlowHeater-Team.
Please Log in or Create an account to join the conversation.
- Andrew Wojciak
- Topic Author
- Offline
- User
Less
More
- Posts: 21
9 years 9 months ago #2346
by Andrew Wojciak
Replied by Andrew Wojciak on topic selecting records in date range
Thank you, Robert.
Great solution and works perfectly.
AW
Great solution and works perfectly.
AW
Please Log in or Create an account to join the conversation.
Time to create page: 0.280 seconds