Date calc - i need help

[Don Gabo]

Hello,

i was wondering someone can help me with this. basically i have date calc that count how many days has pass since the student have being withdrawn and when a refund need to mail. i am able to count the days but i am trying to figure out how to stop counting the day after certain date.

this is how my calc look for the outstanding days

Today- StudentWithDrawDate

Since i know date the refund is mail, i was wondering if i can use that to stop the counting.

i basically want to know how many days took for the student to get the refund.

i am using filemaker pro 6.

thank you

vic

[mr_vodka]

First do not use the 'Today' function. It is well documented as unstable.

Second, you can do something like this.

Case( not IsEmpty(DateMail) , DateMail - StudentWithDrawDate, Status( CurrentDate) - StudentWithDrawDate )