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

From some quick testing this looks like it will work for you `TO_CHAR(MAX({trandate}), 'DD/MM/YY')` and change the field type to Formula (Text)

Nw, just making sure you saw :slightly_smiling_face:

ffs these unexpected errors are infuriating. how are you even suppose to troubleshoot it

i’m using this in a formula text summary max field:

`DECODE({item}, 'XXX', TO_CHAR(MAX({trandate}), 'DD/MM/YY'), NULL)`

and i find myself with the unexpected error

:thinking_face: I'm getting the same result when I try with a decode, but putting the MAX on the outside seems to work

`TO_CHAR(MAX(DECODE({item}, 'XXX', {trandate}, NULL)),'DD/MM/YY')`

and with a date that actually looks correct

i’m also using `ROUND({today}-{trandate})` to calculate the amount of days since that product has been ordered

like so. how can i incorporate that into the formula?

assuming it would actually be pushing the luck to have a field formatted like this:

{quantity} ‘/’ {trandate} ‘/’ {today}-{trandate}

i suck at multi formula fields

i think `SUM(DECODE({item}, 'XXX', {quantity}, 0)) || ' / ' || (TO_CHAR(MAX(DECODE({item}, 'XXX', {trandate}, NULL)),'DD-Mon')) || ' / ' || MIN(ROUND({today}-{trandate})) || 'd'` is doing the job