I have a SQL Server table that I want to use a SELECT query on.
The Selected table is tblORDER, and the field I want to query for is OrderDate. The Dates in the Query are saved in the following format:
I want the result to say something like:
Week 2 of July
How can I do this?
Thank you in advance,