What you'll need is the date or getasdate function to convert the data into a date data type.
Let ( [ Dt = YourTable::YourDateTextField ;
Mn = MiddleWords ( Dt ; 2 ; 1 ) ;
M = Ceiling ( Position ( "JanFebMarAprMayJunJulAugSepOctNovDec" ; Left ( Mn ; 3 ) ; 1 ; 1 ) / 3 ) ;
D = MiddleWords ( Dt ; 3 ; 1 ) ;
Y = RightWords ( Dt ; 1 ) ];
Date ( M ; D ; Y )
Use this calculation with either a field of type date where this is an auto-enter calculation or in a calculation field that returns date as its return type.
Thanks. I cant quite seem to get this to work.
I always get 01/01/0001 as the result.
I have broken down M, D and Y into their constituent parts and these all evaluate correctly.
M, D and Y are all defined as numbers.
The resulting date field is defined as a date. any suggestions ?
Have found the bug. Field was being reset. sorry !!