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.

You should use ({today}-{custom_date_fieldid}) it will give you no.of of dates between two dates.

I am using SuiteQL Like the following...