AnsweredAssumed Answered

Calculation Field for Invoice Dates

Question asked by ChrisCameron on Feb 19, 2015
Latest reply on Feb 19, 2015 by philmodjunk

Title

Calculation Field for Invoice Dates

Post

Have set-up a Inventory Database. I have a Work Order layout that I would like to run reports off of how old invoices are and then place the invoice totals.

For example  If (Work Orders::Date of Work Order <= 30; "30 days or less"; Work Orders::Cost)

 

When I enter in the above formula it doesn't limit the cost to just the invoice 30 days or less. Any suggestions would be helpful. Would ideally like a 30 or less, 60 or less, 90 or less. 

Outcomes