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.
SOLVED

First day of a week

Highlighted
6 - Meteoroid

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

 

 

Highlighted
9 - Comet

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

 

Highlighted
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

Highlighted
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.

 

DateTimeAdd(DateTimeAdd(DateTimeTrim(DateTimeNow(),'year'),[week]*7,'days'),switch(DateTimeFormat(DateTimeAdd(DateTimeTrim(DateTimeNow(),'year'),[week]*7,'days'),'%a'),0,'Mon',-1,'Tue',-2,'Wed',-3,'Thu',-4,'Fri',-5,'Sat',-6,'Sun',0),'days')

Labels