This discussion is archived
6 Replies Latest reply: Mar 13, 2013 5:51 AM by ZFMA86 RSS

Counting or summing everything before today's date

ZFMA86 Newbie
Currently Being Moderated
Gurus,

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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points