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,


From: []
Sent: Tuesday, 12 April 2016 15:16
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





Posted by: "Graham Mandeno" <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)



Tidak ada komentar:

Posting Komentar