h8rt3rmin8r

normalizeTimezone.airtable

Dec 1st, 2019
206
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. IF(LEN(TRIM({dt_z}))=5, IF(LEFT(TRIM({dt_z}), 1)="-", SUBSTITUTE(TRIM({dt_z}),"-","1"), IF(LEFT(TRIM({dt_z}),1)="+", SUBSTITUTE(TRIM({dt_z}), "+", "2"), "")), "null")
RAW Paste Data