Date Caluculation - Please help!

[cbntoronto]

I am in the process of designing a database that counts the days that a job is in progress. For instance, I want to be able to count how many days it takes a job from the time its opened to the time its sent to billing. I have date fields in which the dates are entered however I can seem to get FMPro to count the amount of days in between.

What am I overlooking and is there an easy, efficient way to do this?

Thanks!

[slstrother]

Subtract the date entered from the date to billing.

Days= DateEntered-DateToBilling

Set your calculation result to number.

[cbntoronto]

I ended up getting a negative number, so I multiplied the equation by -1. Works great.

Thanks so much!

[slstrother]

Sorry, I wrote the calc wrong. Reverse the fields.

should be

Days = DateToBilling-DateEntered