Convert ICUDateTime to Unixtime

[peternlewis]

@peterjenkins

But I thought that it might be more efficient to use Search and Replace to convert the hyphens, space and colons into commas -- 2020,08,10,12,00,00, and then %Calculate%TIME(%Local_DateTime%) - GMTOFFSET()%, where %Local_DateTime% is the variable with the value 2020,08,10,12,00,00.

KM doesn't seem to like that, although %Calculate%TIME(2020,08,10,12,00,00) - GMTOFFSET()% -- where I have pasted in the character string 2020,08,10,12,00,00 -- is fine.

Correct, you cannot put text tokens in a numeric field, so in a numeric field, you cannot do TIME(%Local_DateTime%). Similarly, in a text field, which you can use the %Calculate%numeric field% token, but within the numeric field part, you are effectively in a numeric field and so cannot use text tokens.

You can do this:

Note that the second action, being a text field, processes the %DateTime% token (I removed the Local so that the values show in the action). so that the Time variable is set to TIME(2020,08,10,12,00,00). And then you can use the Filter action to calculate the value stored in there.

Note that in a numeric calculation, when you reference a variable, Keyboard Maestro will actually evaluate it to determine it's value, so if it contains TIME(2020,08,10,12,00,00) you can freely use that in a numeric field contact, for example:

Note that the fields in each of these actions is a text field, not a numeric field, so each one is processing text tokens. Only the part in the middle of the last action (Time - GMTOFFSET()) is a numeric field. Keyboard Maestro retrieves the numeric value from the Time variable by evaluating TIME(2020,08,10,12,00,00).