How do I convert a numeric "string" into a date?
I´m a new user and I´m trying to convert a nummeric string into a jmp date format. I tried creating a new column by concatenating a character string so that could at least get my desired "ddmmyyy" output: (Substr( :START_DATE, 7, 2 ) || Substr( :START_DATE, 5, 2 )) ||Substr( :START_DATE, 1, 4 ) but that didnt get´me any further. Any ideas on this?
dale_lehman