Trying to add a simple “age in days” to a PO saved search. Using Formula Numeric, with ROUND(({today}-{trandate}),0) but getting a “date functions may only be used with date type fields”. Is one of these a date/time and messing this up or something?

Did you try this function?

yes, but still wants the formula put in. I think I might have found something in SuiteAnswers, to try a Formula(text) rather than numeric

yeah that's why i was saying age in days function would eliminate the formula 😉

I hadn’t tried it with selecting a date field only, rather than a formula. Stupid, should have known.

lol, it's all good, i try the functions first before i try to figure out the formulas. as i need uncle google to figure that out

ok… advanced question… how would you do an Age in Days… but excluding weekends?

for that you need formula,

Excellent. Thanks!

There are two different SA's but it's same formula i am guessing SA 85632