The example below is an expression which is entered as an advanced filter. To enter this example, select Use Advanced Filter.
|
Action |
Expression |
|---|---|
|
Filter report to only show employees that are absent today. |
(vw_absence.AbsenceFromDate <= Now() AND vw_absence.ToDate >= Now()) OR (vw_absence.ToDate = null) |