nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

3078_en-US

liliconcom

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:

Re: Converting character to Date format

it works tank a lot ..

Pniel

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?

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

Re: Converting character to Date format

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

This seems to work:

Comments

There are no comments yet