function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
María LoboMaría Lobo 

To transfer cases to one queue everyday at the same time

We need to modify some cases (with specifics criterias) to another queue everydat at 5:00p.m European time. (And afterwards also to 1:00am)

An agent gave me a solution:
1. Create a field (Date/Time) than always shows 17:00 Today. The field must be available for all profiles but not available in the Layout

La formula: DATETIMEVALUE(TODAY()+ 0.625)

2. Create a workflow rules with the criterias you need and select "created, and any time it’s edited to subsequently meet criteria "

3. Add a Time-Dependent Workflow Actions that must be 0 hours before the field "Date/Time"
On winter the Time-Dependent Workflow acction must be update with one hour before the field "Date/Time"

4. Add the record updates than will change the owner case from one queue to the other.

The problem is that if I show the Formula Field always shows Today 2:00
And the owner change but not at this time

Does anyone now how could I do it?

Thanks!
pconpcon
Honestly I would just do this with Scheduled Apex [1] and schedule it for the times you need.  If you want to get really "fancy" I'd recommend looking into relax [2] to do this as it handles deployment better when you have jobs that are currently scheduled.

[1] http://blog.deadlypenguin.com/blog/2012/05/26/scheduled-actions-in-salesforce-with-apex/
[2] https://github.com/zachelrath/Relax