This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
