Skip to Content
0
Former Member
Dec 22, 2011 at 12:11 AM

date related error

147 Views

I am trying to take a field, that is a date, that represents the date of the last order from a particular customer and to that add a calculated number of days, a number, expected til receipt of the next order.

So the formula is {@Last Total Ord Date}+({@New Total Days}). This occasionally gives me an error that states "the number of days is out of range".

An instance in which it does NOT give the error is with a customer whose last order date was 10/31/11 and whose number of days til next order is 121. It correctly gives me the result of 02/29/12.

The error is resulting with the next customer, in an instance where that customer's last order date was 11/16/11 and whose number of days til next order is 60.

Awfully confused here......sorry if I appear to be the newbie that I am.

Help would be greatly appreciated. Thank you in advance!

Ted