ps_vbdev (5/26/2015)
many thanks guys ISOWEEK was spot on, never knew about that.
Thanks for the feedback. Just remember that some years have 52 weeks and some have 53. It's the nature of the year being 52.17 weeks long on average. For comparing the last week of each year, you might want to consider using the maximum week of the year.
--Jeff Moden
Change is inevitable... Change for the better is not.