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

tom_abramov — Tue, 12 Mar 2019 07:20:56 GMT

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.

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

gzmorgan0 — Tue, 12 Mar 2019 09:53:36 GMT

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)