Attached is a data table with the conversion formula included. Here is the formula being used
![datetime.PNG datetime.PNG](https://community.jmp.com/t5/image/serverpage/image-id/20466i867AEE619EE9E892/image-size/large?v=v2&px=999)
Date MDY(
Num( Substr( :my Date, 5, 2 ) ),
Num( Substr( :my Date, 7, 2 ) ),
Num( Substr( :my Date, 1, 4 ) )
) + Num( Substr( :my Date, 10, 2 ) ) * 3600
+Num( Substr( :my Date, 12, 2 ) ) * 60
+Num( Substr( :my Date, 14, 2 ) )
Jim