Hi Ladies and Gents-

I have a requirement for a custom object (Catering Requests) that I'm running into issues with.  I want to create a validation rule that will prevent a user from entering a date for their requested catering delivery if it is less than 24 hours notice.  So, if the current system time is 5:00 pm and the requested catering date = Tomorrow at 9:00am I want to throw an error.  Any ideas on how to create that formula?  The custom field is a date/time field called Meeting_Date__c.  

Thanks!

Hi Ladies and Gents-

I have a requirement for a custom object (Catering Requests) that I'm running into issues with.  I want to create a validation rule that will prevent a user from entering a date for their requested catering delivery if it is less than 24 hours notice.  So, if the current system time is 5:00 pm and the requested catering date = Tomorrow at 9:00am I want to throw an error.  Any ideas on how to create that formula?  The custom field is a date/time field called Meeting_Date__c.  

Thanks!

Hello All,
I have completed this challenge.

1-For this first you need to create a helper formula field(type-percent) 
Percent Completed :
(DATEVALUE( CreatedDate ) - CloseDate )/100

2- Then you need to create the actual formula field (type- text) by using the helper formula field.
Opportunity Progress :

IF( Percent_Completed__c <=25,"Early", 
IF(Percent_Completed__c <=75,"Middle", 
"Late"))

Thanks,
Nida