442323_en-US

liliconcom

Formatting Asian dates to short dates

Many companies in Asia type their dates different from that in USA. For example, 3rd Dec. 2021, Asian companies will type it as 03/12/2021 but in USA we type it as 12/03/2021. I have a table which I parse out the dates and convert it into short dates. But the circle ones are wrong, see below image. I used the code below. How do I let JMP know that the dates extracted from the Text column are in this format days_months_year and not months_days_year?

dtlog << New Column( "vStart",Numeric,Continous, Formula(Short Date(Num(LEFT(:Text,8))) )

Attached is the data table.

Data TableScriptingRe: Formatting Asian dates to short dates

Perform these steps:

1. Right click on your vStart column that has the numeric dates

2. Select "Column Info..."

3. Change format from Best by clicking "Best > Date > d/m/y"

4. Click OK

dtlog:vStart << Format( "d/m/y", 12 );

 

 

Re: Formatting Asian dates to short dates

hi mzwald,

How do I merge it with my code?

dtlog << New Column( "vStart",Numeric,Continous, Formula(Short Date(Num(LEFT(:Text,8))) )

Re: Formatting Asian dates to short dates

dtlog << New Column( "vStart", Numeric, Continuous, Formula(Short Date(Num(LEFT(:Text,8)))));
dtlog:vStart << Format( "d/m/y", 12 );