+ Start a Discussion
sumit dsumit d 

create a formula(checkbox field) for measuring if a case has been handled within 24 hours

hi all,
 i want to create a formula for measuring if a case has been handled within 24 hours.
how to do it ?
Any suggestions?
Best Answer chosen by sumit d
Ganesh Hembram 21Ganesh Hembram 21
Hi Sumit,

Create a formula field of type Checkbox and write the below formula.
Note: Change the picklist value based on your requirement.
 
IF( AND( TODAY() > DATEVALUE(CreatedDate ) , ISPICKVAL(Status, 'Working')), true, false)

Regards,
Ganesh Hembram

All Answers

Ganesh Hembram 21Ganesh Hembram 21
Hi Sumit,

Create a formula field of type Checkbox and write the below formula.
Note: Change the picklist value based on your requirement.
 
IF( AND( TODAY() > DATEVALUE(CreatedDate ) , ISPICKVAL(Status, 'Working')), true, false)

Regards,
Ganesh Hembram
This was selected as the best answer
sumit dsumit d
i have a text field   First_Response__c. i want to match this with (created date). not with today .how i will do it .
any suggestions?
Ganesh Hembram 21Ganesh Hembram 21
Hi Sumit,

What exactly you will enter in the text field(i.e. First_Response__c) like Date, Month, Day, Year or any text value(this is a text field)?

So, could you please explain a bit more.

Thanks,
Ganesh Hembram
 
sumit dsumit d
yes this is a text field
Ganesh Hembram 21Ganesh Hembram 21
Hi Sumit,

Okay..!!! I get it its a text field. Could you please explain the below

What happen if you enter "ABCE" or "Test" in the "First_Response__c" field, then how you will match these value with CreatedDate?
And the return type of CreatedDate is Date/DateTime and you are expecting text as return type.

Thanks,
Ganesh Hembarm
sumit dsumit d
it solved thanks for your help ganesh