Filter by dates in two columns

[Dosuna18]

Hello everyone, greetings.
I have the following table, where I have two columns with the approval date and the date of transactions (creationday) in date years-month-day format.
What I want to do is to associate the approval date of the account with the transactions and to count from that date (approval) 30 days later. For example, if the approval date was February 02nd, it will count the transactions from 02-02 until 30 days, that is, until March 04th. It should be noted that each client has a different approval date but it is the same rule, how can I do it?

[izaychik63]

Take a look on some examples

24751-1-1 — NodePit

Challenge_20_Patient_Network_Days — NodePit

Domain Data — NodePit

[Dosuna18]

Thanks for sharing, I will check it out.

[denisfi]

Hi guys,

Well, maybe some date nodes can help you to see and make some decisions.

Date&time Diff node can calc differences between 1 dates, the result will be a number. Then you can use it at the other node called date&time shift to change this information to add get some period.

This wf can help you with this dummy example.

Here I set a new column called “newdate” to get the diff from dates and add it as a numericam in days (option).

So, this will calc for you the next date and set it as a new column information. Now you can add a Math formula node to add some days or validate it for you too.

Is It helps you?

KNIME_project.knwf (9.1 KB)

Thanks,

Denis

[Dosuna18]

Thanks for sharing, I will check it out.