cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
saitcopuroglu
saitcopuroglu
Level IV

How to convert character formats to date format

Oct 10, 2015 04:27 AM (27007 views)

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.

0 Kudos
11 REPLIES 11
MikeD_Anderson
Staff MikeD_Anderson
Staff

Re: How to convert character formats to date format

Oct 15, 2015 04:36 PM (1699 views)  |  Posted in reply to message from glenn_maxey0 10-15-2015

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

0 Kudos
SDF1
Super User SDF1
Super User

Re: How to convert character formats to date format

Mar 28, 2019 01:41 PM (1267 views)  |  Posted in reply to message from MikeD_Anderson 10-12-2015

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