Printing Friday's Data on Monday

[NattyCat]

Hi,

I have a report which is restricted to

{transaction date} = current date -1

However, on Monday, I need it to show the previous Friday's data, not Sunday's.

Ideas please?

Thanks.

 

[kskid]

I had the same problem.

Here's what I did. I made a copy of the report with

{transaction date} = current date - 3

That you run on Monday's only


Why? If I used a formula to determine dates, then the dates did not appear in Database-Show SQL Query and depending on the size of your tables, it would really slow the process down. In my case, it involved close to a million records.

Cheers,

-LW

 

[NattyCat]

I figured this one out, and I used:

(if dayofweek(currentdate) = 2
then {ReconciliationStatementTbl.CreateDate} = currentdate -3
else {ReconciliationStatementTbl.CreateDate} = currentdate -1)