Perhaps you need:
=[UpdateDate] - Weekday([UpdateDate], 4) + 8
Note that this example is the following Wed, so if UpdateDate is received on
a Wed it gives the following Wed. If that's not what you want, you can
adjust to suit.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mark Hall" <scampitickler@aol.com> wrote in message
news:79558298.0402040709.543b7177@posting.google.c om...[color=blue]
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message[/color]
news:<401f891a$0$1739$5a62ac22@freenews.iinet.net. au>...[color=blue][color=green]
> > The next Wednesday is:
> > =[UpdateDate] - Weekday([UpdateDate]) + 4
> >
> >
> > "Mark Hall" <scampitickler@aol.com> wrote in message
> > news:79558298.0402030316.2b2e855@posting.google.co m...[color=darkred]
> > > Our reporting cycle goes from Wednesday to Wednesday an I need to
> > > calculate the next Wednesday after the update was received.
> > >
> > > If an upate comes in on say a Tuesday (eg 20 Jan 04) then I want a
> > > field on the form to show Wednesdays date (eg 21 Jan 04).
> > >
> > > However, if the update comes in on Thursday (eg 22 Jan 04) then the
> > > field would be updated with the date 28 Jan 04.
> > >
> > > Any help much appreciated.[/color][/color]
>
>
> This hasn't worked. It seems to give the nearest Wednesday so on some
> occasions it will give me a date that has already elapsed (last
> Wednesday) What I need is the next Wednesday for each case.
>
> Does that make sense[/color]
