Hi, how can I calculate the agreement end date when not all months have 30 days?  In my calculation Months is a number field.

Agreement start date + Months/30

 

Thanks in advance....

Edited January 8, 20188 yr by Gilbert13

Can you elaborate it a bit more?

 

As far as I understand, you have a date field which is the agreement start date. Then you have a number field which is the agreement period (months).

 

Now you want to calculate the agreement end date ?

Hi, Siroos12

exactly

This is what @Beverly suggested in another post:

 

Date ( Month ( Agreement Start Date) + Agreement Period ; Day ( Agreement Start Date ); Year ( Agreement Start Date ) )

FileMaker will handle the corrections for leap years and days, too!

Here is the link to that post:

 

https://community.filemaker.com/thread/172829

Edited January 8, 20188 yr by siroos12

Works great...

Thanks...