Combining Multiple Columns with specific formatting
Jun 6, 2018 9:26 AM(720 views)
I am stuck on a concatenate issue for two columns.
I have a full date in Column1 and a Unique Lot number in Column2. My goal is to combine column 1 and 2 with specific information. Here's example of what i have any what im looking for. I am using JMP 13, and was placing a formula directly into the column property instead of JMP Script.
Results(format i am looking for)
2016/01/22 12:00 AM
2015/06/23 01:00 AM
2017/05/24 02:00 AM
I am able to combine three column using:
The result i get is: [2016 1 12]
Which isnt exact format of interest.
I am looking to add the formula directly into a column instead of script. Any help would be appriciated.