Skip to Content
0
Jul 21 at 01:59 PM

DaysBetween Master Data CreateDate and CurrentDate

28 Views

Dear Superusers,

I am currently trying to create a query so that I can see the number of days between the Master data creation date and current date, with below SQL, however, it doesn't work, would you help advice?

SELECT T0."ItemCode", T0."CreateDate", DAYS_BETWEEN (T0."CreateDate", CURRENT_DATE) "days between" FROM DUMMY FROM OITM

Thanks

monnie