ROUND({today}-{trandate}) not giving the correct Agr

AI generated answer (using internal Slack threads):

It seems like you are trying to subtract two dates in NetSuite and round the result. However, you are facing an issue where the

ROUND({trandate} - {today}, 0)

formula is not returning the expected result. The issue might be due to the way NetSuite handles date subtraction. When subtracting two dates, the result is a decimal number representing the difference in days. The decimal part might be due to the time difference. When you use the

ROUND

function, it rounds this decimal number to the nearest whole number, which might not be what you expect. One solution suggested in the threads is to use the

TO_DAYS

function. This function converts a date to a number, which represents the number of days from year 0 to the given date. So, the formula would be

TO_DAYS({today}) - TO_DAYS({trandate})

. This will give you the difference in days as a whole number. Another suggestion is to use the

CEILING

function instead of

ROUND

. The

CEILING

function rounds a number up to the nearest whole number. So, if the difference between the two dates is 5.6 days,

CEILING

will return 6, which might be the result you expect. Please note that the formula type should be set to

Formula(Numeric)

as the result of subtracting two dates is a number. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******