August 31, 200124 yr I want to automate my past-due invoice notification system. It seems to me that when I give a record an invoice date, I could also perform a function that would define, in 4 other fields, when 30, 60, 90, and 120 days have elapsed. Problem is, I don't know how to calculate "30 days in the future from June 30, 2001."
August 31, 200124 yr 30DaysField = InvoiceDate + 30 60DaysField = InvoiceDate + 60 90DaysField = InvoiceDate + 90 120DaysField = InvoiceDate + 120
August 31, 200124 yr Author Thanks CaptKurt, but that is exactly what I tried to do. It didn't work. Since it's a calculation, "+30" just added 30, but didn't return the appropriate date.
August 31, 200124 yr That means that you have a misformatted field somewhere. You either need to make your fields DATE format or you need to use the DateToText function to make them text fields. Making them DATE fields is probably the better way to go.
September 1, 200124 yr Author Thanks. I always forget I need to tell the function what format the calculation should return (i.e., date, number, text).
Create an account or sign in to comment