I am using Integromat to connect with AIrtable.
In Airtable I have got Lookup column that is fetching data from the other table.
In v2 of Airtable Moules such column was returned as Integromat array so I could easilly pick any element out of it.
I...
The full formula that worked for me to convert Time in TZ to GMT and it also works for not integer offsets:
IF(AND({Start Time},{TZ}), DATEADD({Start Time}, DATETIME_DIFF(SET_TIMEZONE({Start Time} , ‘GMT’), DATETIME_PARSE( DATETIME_FORMAT( SET_TIME...
