Creating Dates / Week Ending

[ConstantD]

Hi Everyone,
My work is to set a sell through file. In which I show the sales by reference of products, their stock. This file is on a weekly basis.
I would like to know how I can add on my workflow a column in which I put the week ending (the date of the final day of a week)?

In addition, I would like this date to be automatized whenever I change the excel reader. exemple : if I want to put the sales from week 44, I would like to have put in week ending 01/11/2020

[ipazin]

Hello @ConstantD,

I would take following approach:

• use Create Date&Time Range where you create all dates for current year
• then use Extract Date&Time Fields node where you extract week number and day in week
• follow it by Row Filter or Rule-based Row Filter to leave rows which determine last day in week

From experience week numbers produced by above steps don’t have to match your week numbers so building your own file manually (or semi-manually) might be better option.

Br,
Ivan