Text date as date

[pauldamen]

All,

I have a date field coming in from excel in this format: 01-Feb-16, which is recognized as a text field instead off date.

I tried all kind op functions like num#, date#, with trims but I can't get it to work.

Any suggestions?

Regards, Paul

[Kushal_Chawda]

I agreed ,  this would have worked Date#( YourField, 'DD-MMM-YY') as NewDateField