I am running a scheduled workflow to update some fields on workorders. long story short i want to set a date field to next tuesday, as an example. long version of the story, we have scheduled pickups from specific customers on different days of the week. if a work order was not completed i want to set pickup date for that work order to the day of the week specified on the customer record.

You would probably have to write a case statement for each scenario Make a set field value action with a condition of (customer Pickup date = Tuesday) Then do a case when statement of when today = Wednesday then date + 6, when today = Thursday then date + 5, etc And save Open that action again and click make copy Then change the condition to (customer Pickup date is thirsday) and update the “date + x” calculations in your case statement to get it to all be Thursday's Should only take a 15 min or so to get setup

i'm doing that in a search right now to calculate the value just so we have something. I was hoping there would be a more straight forward way to set the value on record. I guess I'll just have to do it this way.