DateAdd Include Last 3 Days 1

[cwsstins]

CR8.5
If today <> Monday, I need data from yesterday
If today = Monday, I need data from the last 3 days (Sunday, Saturday, Friday).

I'm using a dateadd as such:

if dayofweek(CurrentDate) = crTuesday
    then DateAdd("d", -1, Date(year(CurrentDate),month(CurrentDate),day(CurrentDate)))
    else

...for each day other than Monday. How can I set Monday's statement to include the last 3 days?

 

[kskid]

Try this

if dayofweek(currentdate) = 2 then
  {table.date} in currentdate-3 to currentdate - 1
else
  {table.date} = currentdate - 1

 

[cwsstins]

kskid, that works...thanks much!