I have two controls on a form. This gives me the dates for the week
the top has the following in the control source
=DateAdd("d",-Weekday(Date())+2,Date())
the bottom field has the following in the control source
=Date()
the proper way to determine the weekday is
DatePart("w",[txtMydate]))
Based on a txtMydate field to get a date you can use
=IIf(IsNull([txtMydate]),"",DatePart("w",[txtMydate]))
Jim Wagner
________________________________
________________________________
From: rkulez <[email protected]>
To: [email protected]
Sent: Fri, November 20, 2009 3:00:49 AM
Subject: [ms_access] workdays
Dear friends,
I have two date fields in my form. When I write a date in the first field I
wish the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in
access. Can anyone help? Thanks in advance.
Ruhi Kulez
[Non-text portions of this message have been removed]
