Calculating Elapsed Time

[Divegeek]

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

[stanley]

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

[comment]

Just make sure the calculation field is defined to be unstored (in storage options).

[Divegeek]

Very cool! Works Like a charm! Thanks!