In Access, I am able to derive the German week #'s from an Access table, using datepart, but I can not find a way to do this in MsQuery, as the weeknum function does not facilitate "at least 4 days starting with Monday". Does anyone have a method for doing this from Excel in a query?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Ms Query German Week Nos
- Thread starter jmshik
- Start date
