Forum Discussion
Solved
Calculation question - IF statement in Query Editor for Future Date
I have a column of dates. If an employee has left the department, there is an end date that is in the past. If the employee is still in that department, the end date is listed as 12/31/9999 because p...
Nevermind. I did this:
CALCULATE(COUNTROWS('Pod members'), FILTER('Pod members', [End Date]>TODAY()))
Nevermind. I did this:
CALCULATE(COUNTROWS('Pod members'), FILTER('Pod members', [End Date]>TODAY()))