This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I need to compare a *datetime field* with *now()* in a saved search to find records where the different is more than x minutes. Can't seem to get the correct formula for this. Any suggestions please? Thanks1

`ROUND((SYSDATE+0.333333333-to_date(to_char({DATEFIELDNAME},'DD.MM.YYYY HH24:MI'),'DD.MM.YYYY HH24:MI'))*1440)`

I use a formula(numeric) 'is between X and Y' to highlight records a certain number of minutes old. The 0.3333 value is our time zone offset from SYSDATE. This may shift if you're in a daylight savings area.

It's probably not ideal, but has worked reliably for us for a number of years

Ah ha [sysdate] - thank you!!  I was trying:
today()
now()