https://netsuiteprofessionals.com logo
Title
k

KingDaGreat

02/28/2022, 3:28 AM
Does anyone know how to get the difference between today and a custom date field in netsuite using SQL? currently using JDBC. I've tried multiple syntax from online and history from here but can't get it into work.
r

Ramanand Dubey

02/28/2022, 4:33 AM
You should use ({today}-{custom_date_fieldid}) it will give you no.of of dates between two dates.
k

KingDaGreat

02/28/2022, 4:46 AM
I am using SuiteQL Like the following...