Choose Language Hide Translation Bar
Highlighted
pniel
Level I

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:
4 REPLIES 4
Highlighted
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:
Highlighted
pniel
Level I

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

Highlighted
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?
Highlighted
pniel
Level I

Re: Converting character to Date format

it works tank a lot ..

Pniel
Article Labels

    There are no labels assigned to this post.