why does netsuite hate date/time fields in saved searches so much? i feel like every time i do any sort of calculation with a date field (mainly for KPIs) netsuite will have issues displaying it. as an example:
to_date({custrecord_iip_date_completed}, 'MM/DD/YYYY')-to_date({created},'MM/DD/YYYY')
this will work most of the time, but every now and then it seems to break for no reason. Is there a better way of handling date/time fields?