Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Strange Error
Hi All,
I am writing a report/search to display some information on a custom record, I need to highlight the working days between 2 date fields.
I can do this fine using the below formula as a formula (numeric) which works out the working days and this shows as working on the results of the search.
ROUND((TRUNC(({custrecord_dsa2_assessment_date}-{custrecord_dsa2_assessment_booking_date})/7)*5 MOD({custrecord_dsa2_assessment_date}-{custrecord_dsa2_assessment_booking_date},7) - CASE WHEN TO_NUMBER(TO_CHAR({custrecord_dsa2_assessment_date},'D')) < TO_NUMBER(TO_CHAR({custrecord_dsa2_assessment_booking_date},'D')) THEN 2 ELSE 0 END),0) 0