Divegeek Posted February 10, 2006 Share Posted February 10, 2006 Hi Folks, Quick question, and I cant seem to find an easy answer for in online and in my filemaker 8 books. I'd like to calculate elapsed time from a date entered field. Simple right? Yet, I can't quite figure it out. I want to know how many days have passed since I sent a letter out. Here is the specifics, I have a date_sent feild, then a resolved field. If the resolved feild is not checked, I want to know how many days have passed. I also want to know how many days have passed between date_sent and resolved if the issue has been resolved. As always, thanks so much! Jake Link to comment Share on other sites More sharing options...
stanley Posted February 10, 2006 Share Posted February 10, 2006 Jake: Create a calculation field with the following calculation in it: Case(IsEmpty(date_resolved); Get(CurrentDate) - date_sent; date_resolved - date_sent) Define it to return a number, and it will return the difference in days between today and date_sent if date_resolved is empty; otherwise it will calculate between date_resolved and date_sent. -Stanley Link to comment Share on other sites More sharing options...
comment Posted February 10, 2006 Share Posted February 10, 2006 Just make sure the calculation field is defined to be unstored (in storage options). Link to comment Share on other sites More sharing options...
Divegeek Posted February 10, 2006 Author Share Posted February 10, 2006 Very cool! Works Like a charm! Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6649 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