Hi,

I am having a little problem with my calculation of expiry date.

I wanted to do base on date of invoice and then calculate the expiry date of the invoice base on given number of months. How do I do it ?

Thanks in advance

Fei

EXPIRE.zip

Do you want to add a month, or 30 days to your Creation date. If a month, change your calculation to:

Date ( Month ( CREATION ) + WARRANTY MONTH ; Day ( CREATION ) ; Year ( CREATION ) )

If 30 days, change your Warrenty to 30 instead, and your current calculation will work. So that you know, when you add a number to a date in FileMaker, it assumes you are adding days.

Lee

Edited June 25, 200619 yr by Guest

Thanks a lot.