Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

First day of a week

6 - Meteoroid

Hi, I have a week number like a 35 and I need the first day of this week.



9 - Comet

You'll need to have the year associated with the week number and then you can utilize one of these solutions.


8 - Asteroid

There are some other good leads to a solution above.  It all depends on how you define the first week of the year, but you can calculate a formula to calculate the Monday of the week, order them, then add a record ID.  That will give you a week number.


To calculate the Monday of the week, you can use a formula like the one below.  This is SQL, but you should be able to easily convert it into an Alteryx formula.

Cast(calendar_date - ((calendar_date- Cast('1900-01-01' As Date)) Mod 7 ) As Date) As monday_of_week

Alteryx Partner

Presumes current year by using DateTimeNow() but that could be replaced with an date in a column to get the year of it instead. [week] is then the numeric week number. Using these offsets, Sunday is first day.