Skip to Content
0
May 13, 2020 at 11:04 AM

Date Different query in SAP Business One HANA

120 Views

Dear Experts,

A customer wants an SAP Business One query that will show the days between the currentdate of invoice to the date the invoice was created?

I tried this query but it did not work.

SELECT DAYS_BETWEEN(TO_DATE(T0."DocDate", 'YYYY-MM-DD' , TO_DATE(CURRENT DATE(), 'YYYY-MM-DD') AS "Days_Between" FROM OINV T0;

Your Urgent assistance on how to work on the above query for it to work will be appreciated.

Regards

Justice