Report template Select statement

[bradlegassick]

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.

[Aleksi · Accepted solution]

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

[bradlegassick]

Thx @Aleksi report is spot on now!

[Aleksi]

You’re welcome