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
Solved! Go to Solution.
You can use the expression DateTimeFormat(<date/time>, "%U") in the formula tool
From the Date Time Functions
Hello , thnx for your answers i think you didnt understand me good ,
i will give you exemples :
week number YEAR DATE Result that i m looking for is the date of wednesday of that week
15 2021 14/04/2021
2 2021 13/01/2021
14 2021 07/04/2021
Hi @Ayari,
According to ISO-8601 Week 1 is defined as the week with the first Thursday of the year, so I've tweaked @atcodedog05's approach to account for that possible mismatch.
Hope that helps,
Ollie
Hi @Ayari
Please find the enhanced workflow which meets the requirement.
Workflow:
Hope this helps : )
Hi @OllieClarke
@OllieClarke wrote:
According to ISO-8601 Week 1 is defined as the week with the first Thursday of the year.
Interesting I didn't know this about ISO week start 🙂
thnx for you it worked @atcodedog05 , but what is the difference with what @OllieClarke did? can you explain to me coz i didnt get the differences? and the flow you did is applied for any years even for dates in 2022 or 2023 or 2020?
Actualy i found that it is not correct @atcodedog05 taking an ewemple of week n° 3 and the year 2021 it will gives us 06/01/2021 but its not correct it should be 20/01/2021