AnsweredAssumed Answered

Calculation Field for Invoice Dates

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


Calculation Field for Invoice Dates


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.