Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting the date for next Sunday ??

Status
Not open for further replies.
NFLDUser

NFLDUser

IS-IT--Management
Joined
Apr 17, 2006
Messages
47
Location
CA
I'd like to find a way to get the date for the next Sunday from the current date. How would I go about this?
 
Sort by date Sort by votes
Try
Code: 
Dim NextSunday As Date
NextSunday = Dateadd("d", 8-WeekDay(Date), Date+7)

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Upvote 0 Downvote
Excellant, thanks!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question Question
Strongm.... only for you - check if the customer have riceved the email
Replies
2
Views
553
sal21
sal21
sal21
  • Locked
  • Question Question
SORT DATE in msflexgrid not correct
Replies
4
Views
530
sal21
sal21
S
  • Locked
  • Question Question
Replace the chart in the array and substitute the name in textboxt multiline(Vb6)
Replies
0
Views
255
satriano
S
sal21
  • Locked
  • Question Question
I can't find the routine to download the image file anymore
Replies
1
Views
363
strongm
strongm
sal21
  • Locked
  • Question Question
for strongm site down?
Replies
3
Views
525
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top