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: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
tom_abramov
tom_abramov
Level V

converting a date from a string into a JMP date : AM/PM vs 24hr time problems

Mar 12, 2019 03:20 AM (2219 views)

Hi,

I'm having trouble converting values like 

08:49:46 PM
10:30:46 AM

from Character Column to Numeric h:m:s 24h format.

I would like to run the conversion without JSL and without depending on Operation system time format. 

 

Please assist.

Regards,

Tom.

0 Kudos
1 REPLY 1
gzmorgan0
Super User (Alumni) gzmorgan0
Super User (Alumni)

Re: converting a date from a string into a JMP date : AM/PM vs 24hr time problems

Mar 12, 2019 05:53 AM (2207 views)  |  Posted in reply to message from tom_abramov 03-12-2019

Change your format to Duration, or  Format( "hr:m:s", 13, 0 ).  Note the other format with AM and PM is Format("h:m:s",13,0)

0 Kudos

Recommended Articles