MTD MEANS REPORT FROM THE STARTING DATE OF THE MONTH AND 
CURRENT DATE  EX:I WANT A REPORT FOR THE MTD AUGUST MEANS
The report start date must be august 1st to today date(4 
aug).same for the YTD.


WHERE WE CAN USE MEANS WE CAN USE SALES AND INVENTORY ITS 
DEPENDS UPON U R REQUIREMENT

Eg for the MTD report is

select sal from emp where hiredate between
trunc(sysdate,'mm') and sysdate;
same for the ytd,qtd place yy or q respectively