How to convert string into dates. Example: 06-AUG-2018 --> Date
Hi JMP community, I would like to know if there is a more efficient way to translate a date string in the format 06-AUG-2018 into a JMP date. Here is what I have used in the past:Local( {t1},
t1 = Match( Word( 2, :Date of Collection, "-" ),
"JAN", 1,
"FEB", 2,
"MAR", 3,
"APR", 4,
"MAY", 5,
"JUN", 6,
"JUL", 7,
"AUG", 8,
"SEP", 9,
"OCT", 10,
"NOV", 11,
12
);
Date MDY(
t1...
uwe_hiss