Query with Quarter !!!!

SLauren

Hi Guys,
I have a query to write which will return the sum of amounts for different quarters in a year.But the problem is, the financial year may start from any of the months, not necessarily from Jan always.

I have already written the query for finding these amounts if the financial year starts from January. Can anyone please help me to achieve this?

Thanks in advance,
Lauren

dlite922

Post your query.

Dan

SLauren

I have written the following query for retrieving sum of amounts based on quarter if the financial year starts with Jan:-

Expand|Select|Wrap|Line Numbers

 SELECT  SUM(MSB.NetQnty) Total 

FROM

    MSA

INNER JOIN 

    MSB

ON 

    MSA.ID = MSB.RefID

WHERE

    MSA.Anchor_ID = intAnchorID

AND 

MSA.Org_ID = intOrgInstance

AND

MSA.InvoiceDate >= DATE_SUB(CURDATE(),INTERVAL 4 QUARTER)

AND 

MSA.InvoiceDate <= CURDATE()

AND

MSA.RecordStatus = 1

AND

MSB.RecordStatus = 1

GROUP BY QUARTER(MSA.InvoiceDate);

Thanks,
Lauren

SLauren

I worte a customized Quarter function which will take care of the financial year issue.

Thanks,
Lauren

Query with Quarter !!!!

re: Query with Quarter !!!!

re: Query with Quarter !!!!

re: Query with Quarter !!!!

/bytes/development

/bytes/it

/bytes/about