Skip to main content
Topics#Data ManagementDomanda di Ben Patterson
Ben Patterson (Pentair) ha fatto una domanda in #Data Management
30 lug 2010, 18:18

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 risposte
  1. Ben Patterson (Pentair)
    2 ago 2010, 17:16
    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.
Scrivi una risposta...
0/9000