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.