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

:wave: Hi everyone! How to do end_date - start_date = how many days it takes

Can you check if this works, not on system right now.
ABS(TO_DATE({endate})-TO_DATE({startdate}))

Otherwise use this
TO_DATE(TO_CHAR({enddate}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') - TO_DATE(TO_CHAR({startdate}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'))