Identify the next wednesday

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Hi ,

Hope you can help.

I have a date field [enddt] and need to query/function that will return the
date of the next Wednesday after the date in the [enddt].

Any help you can offer will be greatly appreciated .

Thanks
Pete
 
Hi,


NextWednesday = someDate+ Choose( WeekDay(someDate), 3, 2, 1, 7, 6,
5, 4 )



Hoping it may help,
Vanderghast, Access MVP
 
Pete,

Try this:
=[enddt] + 7 - IIf(Weekday([enddt], 5) = 7, 0, Weekday([enddt], 5))

HTH,
Nikos
 
Thanks, folks both of these work fine.

Pete


Nikos Yannacopoulos said:
Pete,

Try this:
=[enddt] + 7 - IIf(Weekday([enddt], 5) = 7, 0, Weekday([enddt], 5))

HTH,
Nikos

Pete said:
Hi ,

Hope you can help.

I have a date field [enddt] and need to query/function that will return the
date of the next Wednesday after the date in the [enddt].

Any help you can offer will be greatly appreciated .

Thanks
Pete
Click to expand...
Click to expand...
 
Back
Top