Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5396 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hi

I have many sell records which start from 1 feb 2009, until now I want to count no. of month(it should be 15 months) in the calc. field but I don't know what function should be used. By using month(date), I face the problem of different year and can't count month.

I need your help.

Thanks.

Posted

Try =


12 * ( Year ( Get(CurrentDate) ) - Year ( StartDate ) ) + Month ( Get(CurrentDate) ) - Month ( StartDate ) - ( Day ( Get(CurrentDate) ) < Day ( StartDate ) )

This topic is 5396 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.