how do I obtain data for Friday & Saturday on a Monday

  • Thread starter Thread starter shifty
  • Start date Start date
S

shifty

I am using the formula which runs a query to obtain the previous day's data
(Friday's data on a Monday). I want to also run a query which gives me
Saturday's data on a Monday sparately from Friday's data - is this possible?

IIf(Weekday(Date(),2)=1,Date()-3,Date()-1)
 
shifty said:
I am using the formula which runs a query to obtain the previous
day's data (Friday's data on a Monday). I want to also run a query
which gives me Saturday's data on a Monday sparately from Friday's
data - is this possible?

IIf(Weekday(Date(),2)=1,Date()-3,Date()-1)
Click to expand...

In a separate field? Why not? Just modify your expression accordingly.
 
Back
Top