I have a table of Collection Events where each collection event is later assigned a Disposal Event. (There are many collection events associated with a single Disposal Event)
I’ve been unable to solve the expression needed to fire a workflow from the Collection Event table if in the associated Disposal Event table the [Timestamp] column = Today()
All I’ve been able to come up with is something like:
IN(Disposal Event), [Timestamp]= Today())
Any thoughts? Thanks in advance.