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
Content aside
- 15 hrs agoLast active
- 10Views
-
1
Following
