Senin, 11 April 2016

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)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar