Time elapse

[Allegheny]

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."

[Kurt Knippel]

30DaysField = InvoiceDate + 30

60DaysField = InvoiceDate + 60

90DaysField = InvoiceDate + 90

120DaysField = InvoiceDate + 120

[Allegheny]

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.

[Kurt Knippel]

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.

[Allegheny]

Thanks. I always forget I need to tell the function what format the calculation should return (i.e., date, number, text).