Need function that returns a date that is 2 weeks from Now()

  • Thread starter Thread starter Ivan Starr
  • Start date Start date
I

Ivan Starr

Hello thank you for helpin with this question that is undoubtedly unworthy
of such greatness.

How do I get a mm//dd/yyyy formatted date back that is Now() plus 2 weeks in
VB for Access(97)???

Please tell me o great oracle of knowledges that you must be if you answer
this question because that would proove it...
 
If you want just the date part, use Date instead of Now:

Date2WeeksFromNow = DateAdd("ww", 2, Date())

Then display the format you want by using the Format function:

strDate2WeeksFromNow = Format(Date2WeeksFromNow, "mm/dd/yyyy")
 
Function TwoWeeksTime() As Date
TwoWeeksTime = Now + 14
End Function

Dates in Access are stored as a number with the whole number part being the
date and the decimal being the time as a fraction of a day.
John
 
Back
Top