It worked...Thanks once more Lovell for your help about my GETDATE() problems 😀

....Related report is only for Year To Date and Monthly figures....Ppl who wants last months reports is using...

HERE IS THE QUERY :

Select cust_code as CUSTOMER_ID, cust_inv_date as ISSUE_DATE, cust_inv_amount as AMOUNT, cust_inv_no as INVOICE_NO from dbo.cust_inv_issued where cust_code = 'MICROSOFT' and

day(cust_inv_date )>= 01 and MONTH(cust_inv_date )= 10...

IT WORKED!!!!!! God Bless You Lowell...

Dear Ashish,

It is datetime....

UPPSS.....I guess I can not paste here a small size off print screen image :blink:

DEAR LOWELL,

Thank you very much for your detailed and educational reply 🙂

Although I do not want to stripp off the time portion unfortunately it did not work :ermm:

LEt me tell...

""""""GetDate also returns the time, would that be the cause of your problem?"""""

....No I don't think so ...The first line is also returns time..In fact I,also, need time data...