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!

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

Week Ending Default

Status
Not open for further replies.

Vette00

Programmer
Oct 8, 2006
21
US
I am looking for some code that will always return the week ending date. The code will open a form for the current week. I tried the Week ID but ran into problem with the year change over. The code will than be passed into a text to set the max date for the data and the min date will be six days before. I hope this makes sense.
 
Hello:

This does it: Put in a text control or use VBA

MyDate = Date - Weekday(Date) + 7
Regards
Mark
 
Thank you so much my brain is cooked and I just couldn't think anymore.
 
Hello:
Your welcome and good luck with this
Regards
Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top