Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
tom_abramov
Level V

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

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.

1 REPLY 1
Highlighted
gzmorgan0
Super User

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

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)

Article Labels

    There are no labels assigned to this post.