I need to calculate the difference between 2 dates the invoi NetSuite Professionals #suiteql

I need to calculate the difference between 2 dates...

Simon

05/22/2023, 7:56 PM

I need to calculate the difference between 2 dates, the invoice due date with current date. How can I do that with Suiteql

Stephanie Hughes

05/22/2023, 8:04 PM

Copy code

TO_DATE(CURRENT_DATE) - TO_DATE(duedate)

Simon

05/22/2023, 8:04 PM

Quick answer and it's working very well. Thanks a lot

👍 1

15 Views