Create special date variable

KNIME Analytics Platform
#1

Hello,

I would like to create a date variable and use it to name a excel spreadsheet:

i.e. If I execute my workflow today the spreadsheet should have the name “Q2 2022”
if I execute the workflow ond 10th of August, the spreadsheet should have the name “Q4 2022”
…

September 2021 - December 2021 = “Q1 2022”
January 2022 - March 2022 = “Q2 2022”
April 2022 - June 2022 = “Q3 2022”
July 2022 - August 2022 = “Q4 2022”

September 2022 - December 2022 = “Q1 2023”
January 2023 - March 2023 = “Q2 2023”
April 2023 - June 2023 = “Q3 2023”
July 2022 - August 2022 = “Q4 2022”

and so on…

as mentioned after that I would like to use that variabel to name the spreadsheet

image
image790×444 14.1 KB

Thank you for any help!

Best
Markus

#2

@Markus3003 you could extract the quarter from a date column (current date):

image
image1086×490 35.7 KB

And then you could adapt this (using the date as file name, but you could also use a combination of year and quarter as sheet name)

2 Likes
#3

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