How to properly format formula result as date?
Hi,I need to create a Date field in a data set imported into JMP. In the original data, the date is embedded in the date-time format YYYYMMDDhhhhmmss. I wrote the following simple formula and attached it to a new column:Munger(:DATE, 0, 8).The result looks OK but when I change the column format Numeric > Continuous > Date > yyyymmdd, the values change to the format “1904….”.I thought maybe I need ...