Date parse format DD-MMM-YYYY not available ?

[JS_dup_135]

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

[jdunkerley79 · Accepted solution]

Try:

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

[JS_dup_135]

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'