>>>The QUARTER() function returns the quarter. Is there a way to calculate the first and the last date of a calendar quarter? I suppose I can "build" such a function but I was wondering if there is already a "built-in" function for that?
>>>
>>>TIA>
>>
>>In case you need to search by ranges in SQL Server, take a look at this blog post
>>
>>
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/searching-for-ranges-when-you-have-quart>
>Thank you.
You're welcome - of course I could have written the code for you if I would have doubted you can do it yourself as easy.
If it's not broken, fix it until it is.
My Blog