Generating all week numbers between two dates

[a_chhay]

Hi,

I am trying to generate all weeks for each year between two periods.

input		output expected
Date		First_day_week (Monday)	Year	Week
28/12/2016		26/12/2016	2016	52
29/03/2017		02/01/2017	2017	1
25/04/2017		…	…	…
22/05/2020		11/05/2020	2020	20
		18/05/2020	2020	21

Thank you for your help,

Andre

[RolandSchubert · Accepted solution]

Hi @a_chhay ,

I'm not quite sure I got you right, but I tried to create a workflow to generate the weeks in the period range.

Let me know if it works for you.

Best,

Roland

[PhilipMannering · Accepted solution]

Hi a_cchay,

Something like this?

[a_chhay · Accepted solution]

Hi @PhilipMannering and @RolandSchubert,

I've already found a solution of my problem and i forgot to close my case.

I've same idea like PhilipMannering but to get distinct value, I used the module "Unique".

 

Thank you for your help!