I have two date fields. I want to find out the difference in days between those two date fields in a different field on the same record. Explain how this can be achieved

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To find the difference in days between two date fields in NetSuite, you can use a formula in a custom field or a saved search. Here's how you can do it: 1. Using a Formula in a Custom Field: You can create a custom field of type integer or decimal and use a formula to calculate the difference. The formula would be

{today} - {other date field}

. However, this might not work in all cases as the field sourcing tab will not work with formulas unless the data for both fields in the formula is present Before Load. In such cases, you might need to use a workflow. 2. Using a Workflow: You can set up a workflow to calculate the difference using an After Record submit trigger. This will ensure that the calculation is done after all the necessary data is loaded. 3. Using a Saved Search: If you want to find the difference between two date fields on a transaction using a search, you can use a Formula Numeric field in the results. The formula would be

ABS(ROUND({shipDate}-{custcol_ship_date}))

. Make sure to set mainline to false. Please note that these formulas will give you the difference in days. If you need the difference in hours or minutes, you will need to adjust the formulas accordingly.