6 Replies Latest reply on Mar 13, 2013 12:51 PM by ZFMA86

    Counting or summing everything before today's date


      Using the Answers tool in the column formula box, I want to count (or SUM) everything that has a date less than today's date. I have a column labeled "Suspense Date" which has dates in this format: 02/28/2013.

      There are thousands of records with a "Suspense Date" less than that date. What would be a good expression to use to count these? It will also need to update each day when I run the report. I was thinking something like:

      SUM(CASE WHEN "Pending Claim - Suspense"."Suspense Date" <= TODAY'S DATE THEN 1 ELSE 0 END)

      I just need to know what I use to indicate "Today's Date"?

      Thanks in advance!