How to write an IF formula after 9pm?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

So I am trying to write a formula that is a bit complicated.

I am trying to get a ToDate([Date Created]) + Days(1) which is true until 9PM of the Created Date. So after 9pm it needs to go to the next next day. So Day(2)

I Want to say

ToDate([Date Created]) + Days(1) Unless TimeOfDay(21:00) Then Days=Days(2)

I know that isnt a real formula but its the best way I could write it with understanding

Photo of Charles

Charles

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
Not tested but Try this

  ToDate([Date Created])


+ IF(ToTimeOfDay([Date Created])> ToTimeOfDay("9:00 pm"), Days(2), Days(1))
Photo of Charles

Charles

  • 0 Points
Thank you I think it worked. Ill know after 9.