function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SMcCSMcC 

Time Based Case Assignment Rule

I am trying to assign cases (tech support trouble tickets) based on the time of day if the case is created prior to 1pm ET it will go to one user after 1 PM ET to another.
 
There is a Case field CreatedDate which is a Date/Time field but not being a programmer by any means I can't find a formula that will produce a custom field that contains only the time created which I could then use to differentiate which user receives the query.
 
Grateful for any ideas.
 
TCAdminTCAdmin
Hello SMcC,

Here is a formula that will pull the Hour out of a Date/Time field. This could be the Date/Time Opened. This is going to display the hour in GMT so you will have to adjust according to your own location. This should allow you to assign based on this value.

VALUE(MID(TEXT(CreatedDate),12,2))
SMcCSMcC

Hi Chris

that looks like it has solved my problem. Much appreciated

Thanks

Sean
AJFAJF
Just to confirm, the created time is based on the creating user's location, correct? This is a validation that I have been searching for and will use it to update a field if users reassign cases to a new user after 3pm on the day the case is due to be resolved. Thanks for the formula.