Denis

I am having a prolbem with adding interstto my overdue accounts. I have an aging field and an orde total, but is there an easy way to automatically add interest to an invoie that is out 30 days and then keep updating the interst with each statement?

Thanks Chuck, I did try the follwoing with a replace that I saw in one of your other esponse and it worked also, but I think your newest will work beter. Thanks again. New Date= Date( Month( DATE PAID ) , Day( DATE PAID ), "2000" )

Is there a quick way to rpelace old dates that are entered as 8/12/00 and result in a 1900 year? I have tried calculations to get the year and need to replace the 00 with 2000. Any advise?