We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

What is the formula to extract YYY-MM-WW

ASIMALI
5 - Atom

How do I get a date in format of year-month-week from a date column. for example, 01-08-2020  as 2020-01-02 (02 being the 2nd week of the year)

 

if its 12th week of the year 2020. I want it to show as 2020-03-12

and if its 52nd week then 2020-12-52

2 REPLIES 2
ydmuley
12 - Quasar
12 - Quasar

@ASIMALI 

 

You can use this formula in the formula tool:

 

DateTimeFormat([Field1],"%Y-%m-%W")

 

ydmuley_0-1585571288387.png

 

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
ASIMALI
5 - Atom

Thank you! worked!

Labels