Skip to main content
Topics#Data ManagementBen Patterson의 질문
Ben Patterson (Pentair) 님이 #Data Management에 질문했습니다
2010년 7월 30일 오후 6: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개
  1. Ben Patterson (Pentair)
    2010년 8월 2일 오후 5: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.
답변을 작성하세요...
0/9000