That his script doesn’t work when timezone is negative, @minks do not do probably any test…
And also have some other errors, so I write my own version on previous post on this topic & related new versions on links.
For example, if you live on GMT-04:00, the script if is queried with apr/22/2023 16:33:41 reply with unexpected invalid value…
-2612771675 (Wednesday 16 March 1887 14:05:25)
For convert generic datetime to unix is already existant one working script:
http://forum.mikrotik.com/t/script-to-inform-by-email-when-the-equipment-was-restarted-due-to-power-failure/165451/10
I copy that script here for simplicity
:global datetime2epoch do={
:local dtime [:tostr $1]
/system clock
:local cyear [get date] ; :if ($cyear ~ "....-..-..") do={:set cyear [:pick $cyear 0 4]} else={:set cyear [:pick $cyear 7 11]}
:if (([:len $dtime] = 10) or ([:len $dtime] = 11)) do={:set dtime "$dtime 00:00:00"}
:if ([:len $dtime] = 15) do={:set dtime "$[:pick $dtime 0 6]/$cyear $[:pick $dtime 7 15]"}
:if ([:len $dtime] = 14) do={:set dtime "$cyear-$[:pick $dtime 0 5] $[:pick $dtime 6 14]"}
:if ([:len $dtime] = 8) do={:set dtime "$[get date] $dtime"}
:if ([:tostr $1] = "") do={:set dtime ("$[get date] $[get time]")}
:local vdate [:pick $dtime 0 [:find $dtime " " -1]]
:local vtime [:pick $dtime ([:find $dtime " " -1] + 1) [:len $dtime]]
:local vgmt [get gmt-offset]; :if ($vgmt > 0x7FFFFFFF) do={:set vgmt ($vgmt - 0x100000000)}
:if ($vgmt < 0) do={:set vgmt ($vgmt * -1)}
:local arrm [:toarray "0,0,31,59,90,120,151,181,212,243,273,304,334"]
:local vdoff [:toarray "0,4,5,7,8,10"]
:local MM [:pick $vdate ($vdoff->2) ($vdoff->3)]
:local M [:tonum $MM]
:if ($vdate ~ ".../../....") do={
:set vdoff [:toarray "7,11,1,3,4,6"]
:set M ([:find "xxanebarprayunulugepctovecANEBARPRAYUNULUGEPCTOVEC" [:pick $vdate ($vdoff->2) ($vdoff->3)] -1] / 2)
:if ($M>12) do={:set M ($M - 12)}
}
:local yyyy [:pick $vdate ($vdoff->0) ($vdoff->1)] ; :if ((($yyyy - 1968) % 4) = 0) do={:set ($arrm->1) -1; :set ($arrm->2) 30}
:local totd ((($yyyy - 1970) * 365) + (($yyyy - 1968) / 4) + ($arrm->$M) + ([:pick $vdate ($vdoff->4) ($vdoff->5)] - 1))
:return (((((($totd * 24) + [:pick $vtime 0 2]) * 60) + [:pick $vtime 3 5]) * 60) + [:pick $vtime 6 8] - $vgmt)
}
example on GMT-04:00
> :put [$datetime2epoch “apr/22/2023 16:33:41”]
1682166821
example on GMT+02:00
> :put [$datetime2epoch “apr/22/2023 16:33:41”]
1682174021
example on GMT+02:00 withour year, like scheduler next run and log
> :put [$datetime2epoch “apr/22 16:33:41”] (is supposed 2023 from local clock)
1682174021
work also with 1st letter uppercase or all uppercase
> :put [$datetime2epoch “Apr/22 16:33:41”] (is supposed 2023 from local clock)
1682174021
work also with new RouterOS v7.10+ ISO formats
> :put [$datetime2epoch “2023-04-22 16:33:41”]
1682174021
> :put [$datetime2epoch “04-22 16:33:41”] (is supposed 2023 from local clock)
1682174021
work also with only time, like on logs
> :put [$datetime2epoch “16:33:41”] (is supposed apr/22/2023 from local clock)
1682174021
example for “now” (on GMT+02:00)
> :put [$datetime2epoch]
1680806933