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

Calendar week to date

df
8 - Asteroid

Hi,

i want to transform this string into a date "01.2018"

01 is calendar week

2018 is year

 

but i dont know why its not working

 

i used %U.%Y

 

 

grafik.png

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@df,

 

I like using formulas rather than the date time macro

 

DateTimeParse(
padleft(ToString(((ToNumber(REGEX_Replace([text field], "(\d+)\.\d+", '$1'))-1)*7+1)),3,"0")
+right([text field],5),"%j.%Y")

When I tried to simply use %U.%Y, all of the output was 2018-01-01.  I then decided to approximate the data and use the %j (Julian) date.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels