Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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