How can i determine the first full week or the first monday of any given year as a varialbe or field in a SQL select statement
I would like to be able to use this value as a data point in some calculations.
Ex 2011 the first Monday is Jan3 and the Week no associated with that would be Week #2
with out hardcoding the date in the query I would like to have the query calculate this based on current date.
determine the first monday or first full week no for current year calculated from current date?