cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
saitcopuroglu
Level IV

How to convert character formats to date format

Dear All,

I receive data in excel with Date columns in various format (defined as character)

31.02.2015

31.2.2015

Feb 31 2015

.

.

.

and many more..

Trying in excel to format them but does not work for excel import wizard (mac)

How will I convert them to one valid Date Column in JMP?

Thank you in advance for your support.

11 REPLIES 11

Re: How to convert character formats to date format

No, not out of turn at all... My VBA is just really weak  ... sticking to my strengths here!

SDF1
Super User

Re: How to convert character formats to date format

Hi @MikeD_Anderson,

 

  I was having a similar issue as the original post did, but more with converting a date format from German style: dd.mm.yyyy to mm/dd/yyyy.

 

  I tried the InFormat() approach, but it didn't work, whereas the formula in your date example data table worked perfectly! So, I would also mark yours as a correct solution, even though it's not as elegant.

 

Thanks!,

DS