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
geis6geis6 

Need help with date in formula

Lets say I wanted to replace the (NOW()-31) in the formula below with an actual date, lets say 2008-08-18T00:00:00Z,what should be the correct syntax for this?  I have a power user that keeps telling me that he gets errors when ever he tries to create this field on the case object.

IF( AND(ISNULL(ClosedDate),CreatedDate < (NOW()-31)), 31*24

Thanks,
Ward
JakesterJakester
Code:
IF( AND(ISNULL(ClosedDate),CreatedDate < (date(2008,8,18)-31)), 31*24