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?
![jpeg.PNG jpeg.PNG](https://community.jmp.com/t5/image/serverpage/image-id/10175iEB0D0EBDE8566E74/image-size/medium?v=v2&px=400)