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 dencom 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
Apr 17, 2006
47
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
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Strongm.... only for you - check if the customer have riceved the email 1
Replies
2
Views
384
sal21
sal21
sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
233
sal21
sal21
sal21
  • Locked
  • Question
I can't find the routine to download the image file anymore
Replies
1
Views
219
strongm
strongm
sal21
  • Locked
  • Question
for strongm site down?
Replies
3
Views
263
strongm
strongm
sal21
  • Question
WHY the sort dont work in msflexgrid
Replies
1
Views
162
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top