Find a date by the Number of week and year

[Ayari]

Hello , 

I hope you are okey alteryx community ,

I  have a probleme in finding the date of wednesday of a week number and the year ,

For exemple i have the week Number : 1 and the year is 2021 and i m looking to find the date of the wednesday of that week and year that means the wednesday of the first week of 2021 .

I wish you could understand Me , thnx for Helping me 

[atcodedog05]

Hi @Ayari 

I am getting 20th

Hope this helps : )

[Ayari]

hello , you can check with this Data please? u can see that theire is some records with Number of week 3 but with date 06/01 and not 20 !!

[Ayari]

You can see also with many other exemples like Number of week 11 it gives many results and not onley one , i dont know if you see what i mean!

[Ayari]

@atcodedog05 @OllieClarke if you can see with the same N week and year values we find with alteryx many results for exemple 

N week = 3 and year = 2021 it gives us 2021-01-20 and 2021-01-13 i dont understand the probleme

[atcodedog05]

Hi @Ayari 

The highlighted is the output column from Alteryx and its matching

Hope this helps : )

[OllieClarke]

Hi @Ayari,

I'm not sure where the [result with alteryx flow] field comes from, but using my workflow, [Week's Wednesday] matches with [RESULT with excel] for every row. (I'm assuming this is what you're trying to replicate in Alteryx...)