Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BankOfficerHere
Posting Yak Master
124 Posts |
 Posted - 2008-05-30 : 03:24:45
|
| Hi,I'm working in a bank and I'm creating a report for my company. I just started learning SQL last month. I hope this forum would help me. Here's my problem: I have date for the last 6 months. I want to filter current quarter and last quarter data. This means, on the next quarter, the data will automatically moves forward. Is that possible?I would appreciate any help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-30 : 04:59:29
|
| use DATEPART(qq,GETDATE()) to get current quarter |
 |
|
|
BankOfficerHere
Posting Yak Master
124 Posts |
Posted - 2008-05-30 : 06:57:12
|
| Thank you I got that. However, I want the data to move every quarter. Is that possible? |
|
|
|
|
|
|
For reporting purposes