Alteryx Designer Desktop Discussions

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

Date conversion

Sarath27
8 - Asteroid

Hi All,

 

Please help me how to convert the below string to a date format.

 

effectivedate 

45170

 

I want this to be populated as "YYYY-MM-DD". 

 

Please assist me. Thanks

 

 

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @Sarath27 use the formula todate() with your effective date inbetween the brackets.

 

todate_16012024.JPG

Sarath27
8 - Asteroid

No its not working. its shows null

JosephSerpis
17 - Castor
17 - Castor

Attaching workflow so you can see how I did it.

DataNath
17 - Castor

@Sarath27 if you're still getting nulls then it may be the case that your effectivedate field is a string - it needs to be numeric for the ToDate() conversion so you can either use a Select tool to change the data type or add another function to the expression i.e.

 

ToDate(ToNumber([effectivedate]))
Labels