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 <rku...@yahoo.com> To: ms_access@yahoogroups.com 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]