How to calculate a day in advance

[Gilbert13]

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, 2018 by Gilbert13

[siroos12]

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 ?

[Gilbert13]

Hi, Siroos12

exactly

[siroos12]

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, 2018 by siroos12

[Gilbert13]

Works great...

Thanks...