IF Condition for WEEKDAY

[Guest]

I have a query that runs daily. I have the "complete date" field set to "<
Date()-1" So it shows itemse with a recieved date of "yesterday" whenever the
query is run. Well, on Mondays I need to to show Friday (which would be
"Date()-3" ). How can I write an "IF" clause so If the weekday is Monday,
True: use Date()-3 False: Date()-1

Please help,
Angel

 

[Marshall Barton]

I have a query that runs daily. I have the "complete date" field set to "<
Date()-1" So it shows itemse with a recieved date of "yesterday" whenever the
query is run. Well, on Mondays I need to to show Friday (which would be
"Date()-3" ). How can I write an "IF" clause so If the weekday is Monday,
True: use Date()-3 False: Date()-1

Try using: Date() - IIf(DatePart("w", Date()) = 2, 3, 1)

 

[Guest]

This worked for me too:

IIf(Weekday(Date())=2,Date()-3,Date()-1)

 

[Chris2]

I have a query that runs daily. I have the "complete date" field set to "<
Date()-1" So it shows itemse with a recieved date of "yesterday" whenever the
query is run. Well, on Mondays I need to to show Friday (which would be
"Date()-3" ). How can I write an "IF" clause so If the weekday is Monday,
True: use Date()-3 False: Date()-1

Please help,
Angel

Wouldn't that be:

"< IIF(DatePart("w", Date()) = 6, Date() - 3, Date() -1)"

 

[Chris2]

This worked for me too:

IIf(Weekday(Date())=2,Date()-3,Date()-1)

I wrote in Friday's weekday number by mistake.

 

[Guest]

Please help me as well -

I am entering data that is pulled the "next day" and realize that I need to
pull on Monday all the data entered Friday, Saturday and Sunday - can someone
help me write a clause so that this will happen - the item below pulls
Friday's data wonderfully, but how do I accomplish all 3?

HELP!

 

[George Nicholson]

NextDay = IIF(Weekday(MyDate,2)<5, MyDate, MyDate + (8-Weekday(MyDate,2)))

Weekday(MyDate,2) The 2 tells Weekday to use Monday as "Start of week", so
it will return 5, 6, 7 for Fri, Sat, Sun
So: If Mon-Thur, NextDay = the same date. If Fri-Sun, NextDay = the
following Monday (MyDate + 3, 2 or 1).

HTH,

 

[Guest]

Thanks, I'll give it a try - hopefully it'll work - I'll let you know on
Monday when I pull the data - thanks George!