Get Last Quarter Sales

[n90]

So I am writing a query that gets last quarter sales and I'm trying to figure out how to make it so that WHENEVER i run it, it will get the last quarter sales. If it helps the datetime column is called DOCDATE.

 

[namliam]

Did you try googling?

http://stackoverflow.com/questions/11141100/how-to-get-quarter-from-a-date-in-tsql

 

[n90]

Did you try googling?

http://stackoverflow.com/questions/11141100/how-to-get-quarter-from-a-date-in-tsql

I know how to get the Quarter from a Datetime column what I am having issue on is in the WHERE clause making a statement where if current date is Quarter 1 then get Quarter 4 from last year.

 

[namliam]

Basicaly just substract 3 months or 91 days from the system date, then create the quarter from that....
Create a quarter from your table date and stick them both into the where clause.

Or if you want to work with the dates so you can utilize Indexes something along the idea:

   (Month(Date()) in ( 1, 2, 3) and YourTableDate between Dateserial(year(date())-1,9,1) and dateserial(Year(date()), 1,1)-1)
or (Month(Date()) in ( 4, 5, 6) and YourTableDate between Dateserial(year(date())  ,1,1) and dateserial(Year(date()), 4,1)-1)
or (Month(Date()) in ( 7, 8, 9) and YourTableDate between Dateserial(year(date())  ,4,1) and dateserial(Year(date()), 8,1)-1)
or (Month(Date()) in (10,11,12) and YourTableDate between Dateserial(year(date())  ,7,1) and dateserial(Year(date()),10,1)-1)