tomr40 Posted May 19, 2006 Share Posted May 19, 2006 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 More sharing options...
John Mark Osborne Posted May 19, 2006 Share Posted May 19, 2006 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 More sharing options...
tomr40 Posted May 19, 2006 Author Share Posted May 19, 2006 Thanks, John. I got it working! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now