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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jlumley

    DatePart and week 2007/53 ?

    That works until you get a year that acutally has 53 weeks in it. I think the OP's concern is that for businesses that conform to ISO 8601 (start week 1 of the year as the first week containing four days and start weeks on Mondays), 2007 does not have 53 weeks. The next year that has 53 weeks...
  2. jlumley

    DatePart and week 2007/53 ?

    While it is true that there are 53 weeks to some years depending on the first day of the week and what constitutes the first week of the year, the situtation laid out above should not have a week 53. A week has to include seven days so showing Dec 31 as week 53 then showing Jan 1 as week 1 is...

Part and Inventory Search

Back
Top