rogerfire

Genx This is how the formula ended up. If(GetAsNumber(PAYED ACC)< GetAsNumber(S TOTAL)and BILL DATE; Today- BILL DATE;0) rogerfire

LaRetta Adding (and Bill Date) did the trick. Thanks

I want to know how many days a bill is past due from the billing date to what ever the curent day is (today) With the orginal formula it would't do anything when the billed date was empty but now when the the billed date is empty it shows the past due days as a huge number. Thanks for your reply rogerfire

In filemaker 4.0 this is the formula I used for tracking Days Past Due and it works great, but in 7.0 it works fine after you put in a billed date. But before you do it makes a huge past due number. If(PAYED ACC< S TOTAL, Today- BILL DATE,0) In 7.0 it changes the comma's to simi colans and won't let you change them back to coma's Any help would be great