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!
Solved! Go to Solution.
Hey ajaygajree!
Try using datetimeparse([Date field],"%d-%b-%Y") to parse the date time data type from the string field.
Best,
Matt D
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!
Thanks MattD
That worked a treat!
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
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>