We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

DD-MMM-YYYY date not being accepted by Alteryx

ajaygajree
7 - Meteor

Hi All

 

I have a Date field in my data that is in the format  of DD-MMM-YYYY, when I run my workflow Alteryx Designer is not recognising it as a Date.

 

I have looked at the Date Parse Function, but I cannot workout how to get Alteryx to accept this as a date.

 

Any help appreciated!

 

7 REPLIES 7
MarqueeCrew
19 - Altair
19 - Altair
You'll need it in YYYY-MM-DD format for a date
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
MattD
Alteryx Community Team
Alteryx Community Team

Hey ajaygajree!

 

Try using datetimeparse([Date field],"%d-%b-%Y") to parse the date time data type from the string field.

 

Best,
Matt D

ajaygajree
7 - Meteor

Hi MarqueCrew

 

Do you mean I have to convert it to YYYY-MM-DD in my Excel file?

 

Does that not defeat the point of Alteryx!

ajaygajree
7 - Meteor

Thanks MattD

 

That worked a treat!

MarqueeCrew
19 - Altair
19 - Altair
Date fields in Alteryx have that format. The date parse tool got you there.
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
Cen64
6 - Meteoroid

How do I do this if the XLSX file uses Custom dd/m/yy format?

 

The file type imported is Double - when converting to string in Alteryx the DateTimeFormat displayes null

 

Thanks

shahid4280
5 - Atom

 i need to implement the logic inside the query to get

the response as ddmmmyyyy, would be much appreciated if u could help me in this 

 

<ns2:SampleDate>  {fn:data($FetchingLabInfoOutput/ns1:SAMPLE_DATE)}  </ns2:SampleDate>

Labels