Generating all week numbers between two dates

Question

Hi,

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

input output expected       Date First_day_week (Monday)YearWeek28/12/2016 26/12/201620165229/03/2017 02/01/20172017125/04/2017 ………22/05/2020 11/05/2020202020  18/05/2020202021

Thank you for your help,

Andre

generating_dates_between_two_periods.yxmd

RolandSchubert · Accepted Answer

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 Answer

Hi a_cchay,

Something like this?

a_chhay · Accepted Answer

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!