Got a quick question:
I’m creating a select expression for a report… and i’ve managed to make it work ALMOST to the point of perfection but i’ve stumbled on a seemingly simple step.
Here’s my expression:
SELECT( JOB_MAIN_AREAS[MAIN_AREA_UID], AND( IN([Foreman],[Related CHECKPOINT_MASTERs][Job Original Foreman]), [Related CHECKPOINT_MASTERs][CreatedDate] >= [FROM], [Related CHECKPOINT_MASTERs][CreatedDate] <= [TO], ))
My original expression was only included the IN() expression and that was great because i did get a list of areas where the selected [Foreman] = [Job Original Foreman].
And now i simply want to limit this list of areas even more but not just by matching the Forman columns but also by comparing the dates…