Date conversion

[Sarath27]

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

[JosephSerpis]

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

[Sarath27]

No its not working. its shows null

[JosephSerpis]

Attaching workflow so you can see how I did it.

[DataNath · Accepted solution]

@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]))