Hi Jim, I didn´t understand how to use it, could you send me an exemplo. Jefferson
--- Em sex, 20/11/09, Jim Wagner <[email protected]> escreveu: De: Jim Wagner <[email protected]> Assunto: Re: [ms_access] workdays Para: [email protected] Data: Sexta-feira, 20 de Novembro de 2009, 13:18 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_acc...@yahoogrou ps.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] ____________________________________________________________________________________ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com [Non-text portions of this message have been removed]
