Jump to content

Calculating Elapsed Time


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

Recommended Posts

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

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

This topic is 5704 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
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    Chris L 
×
×
  • Create New...

Important Information

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