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.