Skip to Content
0
May 29, 2018 at 05:44 AM

how to get current month data

1789 Views

Hi Expert !

I want to know about ,how to get current month goods issue data.

SELECT t0."DocNum" AS "DocNum", T0."DocDate" AS "Date", T1."ItemCode" AS "ItemCode",
T1."Dscription" AS "ItemDesc", t3."ItmsGrpNam", T1."Quantity" AS "Received Qty", T0."Comments"
FROM OIGE T0
INNER JOIN IGE1 T1 ON T1."DocEntry" = T0."DocEntry"
INNER JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode"
INNER JOIN OITB t3 ON t2."ItmsGrpCod" = t3."ItmsGrpCod"
WHERE (MONTH(t0."DocDate") = '12' AND MONTH(NOW()) = '1' AND YEAR(t0."DocDate") = (YEAR(NOW()) -1)

Thanks

Danish