to build the time axis for several different data sets I need to calc dates in the past and in the future for this axis based on a single date.
Example: I have given Year = 2023 and Month = 06
Now I need to calc the dates in YYYY-MM-DD for the months -20 (in the past) and +20 in the future. For every single month -20 up to +20 I have 1 column.
The Excel shows also what needs to be accomplished. Any idea how to get this filled table?
Your help is really appreciated!
Book1.xlsx (9.5 KB)
Look at Create Date&Time Range — NodePit
Pass starting date as parameter and it has to work.
Hi @dev_python , as @izaychik63 mentioned, the key ingredient here is the Create Date&Time Range node.
However, there are quite a few things to be done to get to the output that you want, and it can be tricky.
I put something together in case you struggle with this. I used the same input data that you have:
I have also parameterized the past and future months via a Variable Creator:
This is the results that I get for a -20 months and +20 months:
The workflow looks like this:
And here’s the workflow: Filling Columns with dates base on given date.knwf (37.5 KB)
Great! Works as expected. Thanks for this!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.