I've checked the docs on the related oracle functions and I don't see what I'm doing wrong (if anything)
Here is the expression I'm trying to use:
TO_NUMBER(NVL2({custrecord_pat_assess_due_time_seconds}, {custrecord_pat_assess_due_time_seconds}, 0))
{custrecord_pat_assess_due_time_seconds} is a free-form text field.
NVL2( {custrecord_pat_assess_due_time_seconds}, {custrecord_pat_assess_due_time_seconds}, '0' )This prints out '1212467209562'TO_NUMBER(1212467209562)
This prints out '1212467209562'So why doesn't:TO_NUMBER(NVL2({custrecord_pat_assess_due_time_seconds}, {custrecord_pat_assess_due_time_seconds}, 0))Work?Any help greatly appreciated.