Have been using the formula numeric to compare two dates in NetSuite via saved search. This was required in purchase order update sync.This formula is used to check whether there are any latest updates on the purchase order. After the PO update sync we will set the updated date on custom date field. The formula… Continue reading Calculate Date Difference in Saved Search if one of the Date is empty
Tag: NVL
NVL Function
NVL(expr1, expr2) : In SQL, NVL() converts a null value to an actual value. Data types that can be used are date, character, and number. The data type must match with each other i.e. expr1 and expr2 must be of the same data type. Syntax – NVL (expr1, expr2) expr1 is the source value or… Continue reading NVL Function