Jump to content

Date Formula


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

Recommended Posts

I'm a Driver Ed teacher using FMP 4.1 (Don't ask. That's what they gave me?) I use FM to manage my Driver Program. I have a need for a formula that will subtract a constant date (3/15/04) from today's system date and will yield a number. In other words, the number of days that have past between 3/15/04 and today.

Thanks,

Link to comment
Share on other sites

The following formula will yield a number of elapsed days:

Status(CurrentDate) - MyDateField

Make sure your calculation field is set to unstored or it won't update as the current date changes. You'll find this option in the calculation dialog when you are entering this formula. There will be a Storage Options button that will reveal another dialog where you tell FileMaker to not store the calculation result.

Link to comment
Share on other sites

This topic is 6524 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.