Knime output filename concatenated with Current MOnth/Year

[rds]

Hi All,
I am trying to concatenate previous month/year in ‘MMM’YY’ format with exported excel filename , which extracted file from knime workflow . So something like -
"Population - Feb’23.xlsx "
Kindly let me know which node can used to get this done.

Thanks
RS

[AlexanderFillbrunn]

Hi @rds,
You can use a Create Date&Time Range node and set the number of rows to 1 and the start date&time to “current execution time”. Then you can use the Date&Time Shift node to subtract one month, followed by a Extract Date&Time Fields to get the year and the month. Now you can concatenate those using a String Manipulation node and create a file name using the Create File/Folder Variables node. This variable you create can then be used in the Excel Writer.
Kind regards,
Alexander

[mlauber71]

@rds you can take a look at these examples:

using the create temp dir node with java edit variable node

You could check this example out. Please note by default the Temp folder will be deleted after reset. You could also create a permanent folder or de-select the delete option. [image]

Excel Name with Date – frankcolumbo