Object: Rent Request
| Field |
Value |
| Rule Name |
RentFromRentUntilTimeBetweenWorkHours |
| Formula: |
??? |
| Error Message: |
Rent From and Rent Until time must be between 9:00 AM and 5:00 PM |
| Error Location: |
Field ➦ Top of Page |
Code
OR(OR(TIMEVALUE( Rent_From__c ) < TIMEVALUE("13:00:00.000") ,
TIMEVALUE( Rent_From__c )> TIMEVALUE("21:00:00.000")),
OR(TIMEVALUE( Rent_Until__c) < TIMEVALUE("13:00:00.000") ,
TIMEVALUE( Rent_Until__c )> TIMEVALUE("21:00:00.000")))
OR
TIMEVALUE( Rent_From__c ) < TIMEVALUE("13:00:00.000") ||
TIMEVALUE( Rent_From__c )> TIMEVALUE("21:00:00.000")||
TIMEVALUE( Rent_Until__c) < TIMEVALUE("13:00:00.000") ||
TIMEVALUE( Rent_Until__c )> TIMEVALUE("21:00:00.000")
