Create a Date based on a Text Field

[hellyars]

Basic question.

This is my formula expression.   I am trying to create a field that turns Name into a Date.

But the results are Null and I see the Conv Error of "Year: 10-03-1995; is not a valid Date.'  ...for every year

Her eis a partial sample.  The elseif statements continued through FY19.

if [Name]="FY96" then '10-03-1995'

elseif [Name]="FY97" then '10-03-1996'

elseif [Name]="FY98" then '10-03-1997'

else null() endif

[hellyars · Accepted solution]

Never mind...

I forgot Alteryx likes YYYY-MM-DD

[danilang]

Hi @hellyars

Dates in Alteryx are always "yyyy-mm-dd" so your formula should be

if [Name]="FY96" then '"1995-03-10"

etc

Dan

[bbak]

Hello Hellyars,

This is because your date needs to me in the yyyy-mm-dd format. I think that if you tweak this you should be good to go!

-Brandon