/thanks for the reply, but the code sample you included does not give me what I'm looking for...
I don't need to know the week number or whether or not a day is a weekday or weekend. I am looking for the same construct as you would find in SSAS - a date that gives the beginning of the week. Every week start on a Sunday.
I am trying to do the same thing in SQL Server, and again, from what I have seen the only two built in functions for SQL Server for getting anything similar is MONTH or YEAR.
I also am not hardcoding dates. As you can see in the code example I posted, I am taking the current date, NOT hard coded dates.
A. M. Robinson
No comments:
Post a Comment