Next Friday

[Alain]

Using Access 2002 I am using a form from which I want to
be able to calculate the next Friday's date from the
current date

Any suugestions as to how this could be done?


Thanks in advance

Alain

 

[John Vinson]

Using Access 2002 I am using a form from which I want to
be able to calculate the next Friday's date from the
current date

You can use the DateAdd and Weekday functions to do this:

=DateAdd("d", 8 - Weekday(Date, vbFriday), Date())

as the control source of a textbox on the form. If you open the form
on Friday it will show the next Friday, not the current day.

 

[Graham R Seach]

Alain,

GetNextFriday = DateAdd("d", IIf(Weekday(Date, 7) = 7, 7, 7 - Weekday(Date,
7)), Date)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Allen Browne]

Next Friday is:
Date() - Weekday(Date(), 6) + 8

That tells Access to assume a week starts of Friday (vbFriday = 6), subtract
the date of the week (which gives you the last day of the previous week),
and add 8 days to get to the next Friday.

 

[Alain]

Wow spolit for choice!!

Thanks for the quick response

Alain