I have a table - Collection Event and a table - Disposal Event. Each collection event is eventually assigned a Disposal Event.
Report is based on the Collection Event table.
I need an expression in the “If This is True” dialogue box of the Collection Event table that fires the report if Column [Timestamp] column type Date in the associated Disposal Event table is equal to today().
I’ve tried a range of expressions and no luck. Many thanks to anyone who can help. Stay safe.