Report template Select statement

Hi, I am using the following Select expression in a report. It generates a table of attendees. This works perfectly if I have a Timestamp for Date Out column. However if someone generates the report & wants current on site people included in the report, it doesn’t provide any results for records with no Date Out field entry. Thanks for the help.

Hi, you need to add OR(ISBLANK([Date Out]),[Date Out]<=…)

4 Likes

Thx @Aleksi report is spot on now! :grin:

You’re welcome