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

[#1]

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?

[#2]

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())

[#3]

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:Date Format Pattern - additional functionality 

and maybe support it with a Kudo  ...