Change state transition is failing due to filter condition

[thrsdy1512]

I have a automatic state transition which should move the change req from 'Implement' to 'Review' when the Planned End Date is now or earlier. 

I have tried to do this different ways and have tried different variations of the filter conditions but the request stays stuck in Implement. If I remove the planned end date filter and apply something else for testing purposes, that works. The issue is around how to create a condition that looks at the planned end date (date/time field). I have also tried to do it as a transition script with no luck.

Thanks

[J Siva]

HI @thrsdy1512 

We cannot update the state value solely based on a date/time condition. State transitions require a trigger to validate the transition conditions—typically a UI action or a field change

Regards,
Siva

[thrsdy1512]

Hi @J Siva Do you know if there is a workaround for this eg using a script? Business requirements are that the change request moves into a 'Review' state once the planned end date is in the past. 

[J Siva]

@thrsdy1512 Once the change moved to implement state, trigger the flow and wait till the planned end date using "Wait for duration" 

Once it's reached the specified time/duration, use the "Update record" action to update the state as "Review"

[thrsdy1512]

@J Siva Thanks. I am facing the same issue with filter condition in the flow as I did with the state transitions, which is the best way to basically have it check if the planned end date/time is in the past? The condition prompts me to enter a date/time but this will be relative depending on when the flow is executed.