topic Re: Timestamp conversion? it just nulls out if I try to format as a timestamp in Discussions

Timestamp conversion? it just nulls out if I try to format as a timestamp

TriangularLlama — Fri, 22 Mar 2024 19:19:06 GMT

2024-01-06 13:59:00+00:00

I am getting timestamps in this format. JMP auto-formats them as Charact-Nominal....How do I get these to be a proper timestamp format?

Re: Timestamp conversion? it just nulls out if I try to format as a timestamp

jthi — Fri, 22 Mar 2024 20:09:28 GMT

Create formula column with formula

Informat(Word(1, :Column 1, "+"))

where :Column 1 is your string formatted "date". This formula will pick anything before "+" and JMP is most likely able to convert that to a numeric format (if JMP isn't able to do that, you might have to add Format pattern to Informat())

Re: Timestamp conversion? it just nulls out if I try to format as a timestamp

hogi — Fri, 22 Mar 2024 23:34:30 GMT

unfortunately, there is no placeholder available yet for timezone offsets like +00:00

but one could hard-code the "+00:00" via

Informat( :Column 1, "Format Pattern", "<YYYY></><MM></><DD> <hh>:<mm>:<ss>+00:00" )

actually no benefit compared to Jarmos version - just a much longer code.
maybe: you can force Jmp to place DD and MM at the right position :)

If you want to parse input with varying timezone offset, you have to split off the timezone info and add it later:

Informat( Word( 1, :input, "+" ) ) + Num( Word( 1, Word( 2, :input, "+" ), ":" ) )
 * 60 * 60

If there are negative offsets as well, it gets harder and harder to parse.

Then you should consider this request from the wish list:

and maybe support it with a Kudo ...