What is the formula to extract YYY-MM-WW

[ASIMALI]

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

[ydmuley · Accepted solution]

@ASIMALI 

You can use this formula in the formula tool:

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

[ASIMALI]

Thank you! worked!