Hi, I have a column called couriers, my requirement is to reset [couriers] when [status]=“Pending” for more than 5 days, the day [status] is set to pending is recorded in [Handover Date]. This is the expression I put in the reset on edit field:
[Status]=“Pending Delivery”,TODAY()>=[Handover date]+5
What is causing the issue and is there a possible work around. This expression already works as a filter in a slice to separate overdue deliveries in a view so I do not understand why it won’t work here.
Any help is greatly appreciated