Dear Jim and Jefferson,
It seems there is something wrong with the formula. Up to my limited knowledge
this formula means "add the number of the day to the date and add 2 on it" .
First of all your formula has a minus sign before weekday and this leads the
result to be an early date. I have removed it and when I test it gives wrong
results without excluding "sundays". For example when the date is 1st of Dec.
the later date seems 6 th of Dec which is Sunday. If the date is 2nd of Dec
then the later date seems 8 th of Dec. excluding monday. I think something is
missing with the formula.
Very best wishes.
Ruhi
--- In ms_access@yahoogroups.com, jefferson ferreira de sousa
<jferreira.so...@...> wrote:
>
> Hi Jim, I didn´t understand how to use it, could you send me an exemplo.
> Â
> Jefferson
>
> --- Em sex, 20/11/09, Jim Wagner <luvmymel...@...> escreveu:
>
>
> De: Jim Wagner <luvmymel...@...>
> Assunto: Re: [ms_access] workdays
> Para: ms_access@yahoogroups.com
> 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]
>
