0

Convert date+time UTC in text format to timestamp

I need help with the following timestamp (in text format) to a date and time (Mountain Time zone) fields:

2026-06-02 06:00:52.742 UTC

I tried with Ninox 4 but the timestamp instruction does not work:

 

let utc_ts := timestamp(utc_timestamp_text);

let utc_year := year(utc_ts);

let utc_month := month(utc_ts);

let utc_day := day(utc_ts);

let is_dst := if utc_month > 3 and utc_month < 11 then

                        true

            else

                        if utc_month = 3 then

                                    utc_day > 14 - weekday(date(utc_year, 3, 1))

                        else

                                    if utc_month = 11 then

                                                utc_day < 7 - weekday(date(utc_year, 11, 1))

                                    else

                                                false

                                    end

                        end

            end;

let offset_hours := if is_dst then -7 else -6 end;

datetime(utc_ts + timeinterval(offset_hours * 3600000))

 

In Ninox 4, it creates a new timestamp for Mountain time. However, when I try it in Ninox 3, it does not work at all.

Reply

null

Content aside

  • 15 hrs agoLast active
  • 10Views
  • 1 Following