The week at our manufacturing plant starts on Monday. To format a date as the number of the day of the week you enter a w in the format box on the property sheet. However that starts the week on Sunday. I know 2 is the number to start the week on Monday but I cannot get the nomenclature correct. w2 does not work, neither does w,2, nor w[2]. Does anybody know what the correct format is? Thanks
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Format date as day of week starting on a Monday on a form
- Thread starter nwtools
- Start date
You can add another argument like:
You can also replace vbMonday with 2 outside of vba.
Duane
Hook'D on Access
MS Access MVP
Code:
? Format(Date(),"w",vbMonday)You can also replace vbMonday with 2 outside of vba.
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question