5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Jan 20, 2020
‎Feb 22, 2024

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...