community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Date parse format DD-MMM-YYYY not available ?

Atom

Hello all. 

Am I correct that Date Parse function does not support converting from format DD-MMM-YYYY (25-Feb-2016) ? 

 

This would be a big surprise, as Excel has no problem with them, and it is a very popular format, for example in Oracle ERP ?

 

Thank you,

JS

Try:

 

DateTimeParse('25-Feb-2016', '%d-%b-%Y')
Atom

Perfect - thank you jdunkerley79  :) 

 

For completeness of information - for beginners like me - the expression needs to be pasted in "Formula" , and use input field:

[Date]

in place of '

'25-Feb-2016'

 

 

Labels