figure date for next week

  • Thread starter Thread starter Associates
  • Start date Start date
A

Associates

Hi,

I need your help with the date. If a date is given (for example the current
date), how do i work out in VBA for Access database that it would give me the
last day(friday) of the next week?

For example today is 13-Feb-2008, Next friday will be 22-Feb-2008. It'd be
great if i could use that kind of format. Today's date is taken from the
user's reply. So i need to know what kind of format that is suitable.

Thank you in advance
 
Untested, but I think this should work

DateAdd("d",13 - WeekDay(Date()),Date())

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
I think that should have been
?DateAdd("d",14 - WeekDay(Date()), Date())


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top