Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Jolomero
5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Jan 20, 2020
‎Jan 14, 2023

User Statistics

  • 9 Posts
  • 1 Solutions
  • 5 Kudos given
  • 4 Kudos received

User Activity

I’ve been having tons of fun learning how to handle DATETIME and IF() and SWITCH(), but I can’t figure this one out. I am measuring the difference in weeks between two calculated dates, and that bit is OK, but I want to replace all of the weeks in t...
I am trying to determine if an appointment date (stored as UTC) is on the same day or a different day depending on the timezone. I think I know how to do this with an IF statement in general: IF(“Date in CTZ1”=“Date in CTZ2",“same”,“different”) but I...