I created a column in saved search for Formula(Date) and set its formula as

{today} - {trandate}

But it shows me this error.

ERROR: Invalid Expression

, I tried to output them separately and both of them are working fine as they out put

7/10/2023

,

7/25/2023

respectively. Could I know what the issue is please? or how to fix this please?

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

Mb's solution would probably work, but I think your issue is your formula type. Switch to Formula(Numeric). The result of subtracting two dates is just an integer. The formula type applies to the result, not the inputs.