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"?
As I said you have to go with timestampdiff function and then validate for 7.
Its very hard to tell with guess
I would do something like below;
TIMESTAMPDIFF(SQL_TSI_DAY, DueDate, MAX(Time.Date BY Week))