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

Try TO_NUMBER(TO_CHAR({today},’YYYY’))

I tried this already and it shows an unexpected error.

Although there's one too many `Y`s in that answer, it should still work.
Make sure you're using `Formula (Numeric)` and not `Formula (Date)`

Interestingly, still worked. It returned "20200"

Now I figured it out why it showed an error. I was using Formula (Text) and was hoping that it will remove the comma due to TO_NUMBER.

Here's the final formula (no comma):

Formula (Text): TO_CHAR(TO_NUMBER(TO_CHAR({today},'YYYY')))