I would like find the week of the date thro sql. The syntax is
Week('01/01/12') will give me the week of this date.
If iam executing this syntax, the week starts from sunday only but i would like to have starting of the week should be Saturday not sunday.
Can any one help me, how to write the sql for the starting week as saturday not sunday.