Date Extraction and Add Date

Hi Guys, I have a question is there a date node that can Identify the quarter and set as identifier to create a column Due Date for rule date tagging.

Every Quarter set a due date (next quarter end of month)

Quarter Bracket Due Date
1st quarter 4/30/2022
2nd Quarter 7/31/2022
3rd Quarter 10/31/2022
4th Quarter 1/31/2023

Input Data
Transaction Date
1/1/2022
1/2/2022
1/3/2022
1/4/2022
1/5/2022
1/6/2022
1/7/2022
1/8/2022
1/9/2022
1/10/2022
1/11/2022
1/12/2022

Output Data

Transaction Date Due Date
1/1/2022 4/30/2022
1/2/2022 4/30/2022
1/3/2022 4/30/2022
1/4/2022 7/31/2022
1/5/2022 7/31/2022
1/6/2022 7/31/2022
1/7/2022 10/31/2022
1/8/2022 10/31/2022
1/9/2022 10/31/2022
1/10/2022 1/31/2023
1/11/2022 1/31/2023
1/12/2022 1/31/2023

hi @seanmanzanilla ,
the node you’re looking for is “Extract Date & Time Fields”
The workflow could be this one
KNIME_temp.knwf (16.9 KB)

1 Like

Hi @duristef,

thank you, last question what if the transaction date will change into year 2023.I need to manually change the Due date table? it their a way to identify using the transaction date?

respectfully,
sean

This is the “dynamic version” of the workflow
KNIME_temp.knwf (11.7 KB)

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.