Skip to main content
Topics#Data ManagementBen Patterson's Question
Ben Patterson (Pentair) asked in #Data Management
Jul 30, 2010, 6:18 PM

Time validation rule

I would like to create a validation rule to prevent a record from being saved if the time is after X.  I have attempted this, but I can't see where I can reference the current time.  Any ideas?
13 answers
  1. Ben Patterson (Pentair)
    Aug 2, 2010, 5:16 PM
    Thank you for the response, here's what I have.

     

    AND (

     

    ISPICKVAL (  Status__c , "Submitted" ),

     

    Due_Date__c  =  TODAY() ,

     

    Current time  <=  4 pm eastern time

     

    )

     

    Due_Date__c is a date field, and the last line is my trouble spot.
Write an answer...
0/9000