get quarters from rolling months

Question

Hello,

I have a table which has the first of the month field fom_dt. its rolling month.

I need to get last 8 quarters dates and that information .

Please tell me how can i do it.

Thanks

madhavi

Answer 1

hmm, something like:

SELECT DATEADD(QUARTER, -1, fom_dt) FROM yourTable ;

Answer 2

Check out the sequence generator scripts in the following article:

http://www.sqlusa.com/bestpractices2005/sequence/

There are examples for temporal sequences such as days, months & quarters.

---

Kalman Toth SQL SERVER & BI TRAINING

Answer 3

Dates within 8 previous quarters

... where  fom_dt between DATEADD(QUARTER,-8,DATEADD(QUARTER,DATEDIFF(QUARTER,'19000101',getdate()),'19000101')) and DATEADD (QUARTER, DATEDIFF(QUARTER, '19000101', getdate()), '19000101' ) - 1

---

Serg