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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
altug_bayram
altug_bayram
Level IV

Character to DateTime Conversion Help Needed

Created: Feb 28, 2023 08:39 PM  |  Last Modified: Jun 8, 2023 9:32 AM (3491 views)

Hi 

 

I am attaching a sample single row table. 

Date1 column is character 

e.g. 03-Mar-22 12.13 PM

ie. DD-MMM-YY HH.MM am/pm

 

Date2 has a datetime format

 

I need a formula for especially Date1 to convert it into DateTime w/ desired format of 

MM/DD/YYYY HH:MM:SS am/pm

(SS, seconds would be automatically zero )

 

My goal is to update a table based on a second one (or join) once I can 2 comparable datetime columns 

note: I tried some attempts, none worked so far. Appreciate the help. 

 

thanks

Char_to_DateTime_Sample.jmp
0 Kudos
10 REPLIES 10
altug_bayram
altug_bayram
Level IV

Re: Character to DateTime Conversion Help Needed

Mar 2, 2023 04:48 PM (479 views)  |  Posted in reply to message from brady_brady 03-01-2023

Brady, 

 

It's been long time and I hope you are doing well. 

 

Your technical solution certainly does well, as it did work great. In the end, it was so simple.

thanks again for your support.