Date parse format DD-MMM-YYYY not available ?

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

Parse

Date Time

Accepted answers

Try:

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

All comments

Try:

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

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'

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703