Choose Language Hide Translation Bar
pniel
Community Trekker

Converting character to Date format

Hello Jmpers,

I have a column of Dates in a character format and I need to convert it to Date format, I tried this:
0 Kudos
4 REPLIES 4
ms
Super User ms
Super User

Re: Converting character to Date format

That particular date format seem not to be supported by JMP.

This seems to work:
0 Kudos
pniel
Community Trekker

Re: Converting character to Date format

Tanks but it still has a problem

When i type this code in gives me NULL values since it is a character

0 Kudos
ms
Super User ms
Super User

Re: Converting character to Date format

You must edit the text into a valid date format before converting to numeric. Otherwise JMP won't recognize it as a date and give a missing value.

It works for me if I have text like "14/3/2011 08:15:00". The Munger-script converts it to "14-3-2011 08.15.00" which is one of JMP's supported time formats.

Or did I misunderstand something about how your dates are formatted?
0 Kudos
pniel
Community Trekker

Re: Converting character to Date format

it works tank a lot ..

Pniel
0 Kudos