correct this formula TO_DAYS({today}) - TO_DAYS({trandate}) it gives invalid expression in the saved search

AI generated answer (using internal Slack threads):

The formula you're trying to use,

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

, is giving an invalid expression error because the

TO_DAYS

function is not recognized in NetSuite saved searches. Instead, you can directly subtract the

{trandate}

from

{today}

. The formula should be

{today} - {trandate}

. This will give you the difference in days between the two dates. Please note that the result of this formula will be a decimal number, representing the difference in days and fractions of a day. If you want to round this to the nearest whole number, you can use the

ROUND

function:

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

. If you want to always round up to the next whole number, you can use the

CEILING

function:

CEILING({today} - {trandate})

. Remember to set the formula type 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. ******