RE: [MS_AccessPros] Re: Select all records of form

 

Hi Ken

[Due Date] + IIf(Weekday([Due Date])=6, 3, 1)

Weekday(Date) returns 1 to 7  : 1=Sunday, 2=Monday, etc

Best wishes,
Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 12 April 2016 15:16
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Select all records of form

 

 

I am now dealing with Fridays. 

 

IIf(DatePart("w",[Due Date]),[Due Date]+3,[Due Date]+1)

 

What am I missing to show that when the Due Date is Friday add 3 days

 

Ken

 

__._,_.___

---

Posted by: "Graham Mandeno" <graham@mandeno.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___