function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Stephen02Stephen02 

Calculate Date based on GMT

Hi - I am wondering if anyone can assist with this formula?
Formula Requirement:

IF the current GMT time = anytime between 07:00 and 18:00 GMT, THEN return a date of today, otherwise return a date of the following day
Best Answer chosen by Stephen02
mritzimritzi
IF(  
     AND(NOW()-DATETIMEVALUE(TODAY())<=18/24, NOW()-DATETIMEVALUE(TODAY())>= 7/24) , 
     TODAY(), TODAY()+1
)

Formulae field type -> DATE


Mark it as Best Answer, if it helps