Date Formula

[tomr40]

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,

[John Mark Osborne]

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.

[tomr40]

Thanks, John. I got it working!