Looking for some advice on my due date calculation.

My calculation is working, but wondering if it is as sound as it could be.

 

due_date = [ invoice_date + terms ]

 

Should this be written better?

Yes. That's very sound and straight forward.

 

Check this out for a reference: http://help.filemaker.com/app/answers/detail/a_id/4129/~/calculating-due-dates-specific-to-each-record-in-the-database

Thanks GisMo

Can't see how this would work. Invoice Date is a date field. What is the field Terms? If it's a payment schedule (30 days, 60 days etc. and also related to date then it's possible. Not enough info.

Can't see how this would work. Invoice Date is a date field. What is the field Terms? If it's a payment schedule (30 days, 60 days etc. and also related to date then it's possible. Not enough info.

invoice_date is a date field

terms is a number field and would be set to 0, 30, 60, etc...

 

Being that the terms field is a number field, you could set it to "Net 30" and FileMaker will ignore the "Net ". But I chose to keep it clean and leave "Due Upon Receipt" and "Net" out of the terms field.

 

Instead I created a terms_label calculation that is displayed on invoice report...

 

 

Case(

terms ≤ 0; "Due Upon Receipt"; "Net " & terms

)