G
Guest
I ran an Office update a couple of days ago, and suddenly a formula is
producing an incorrect answer intermittently:
Due Date: [From
date]-IIf([Country]="",IIf([nights]>20,90,60),IIf([nights]>10,90,60))
In most cases the calculation is correct, but about once in 5 cases, it's
calculating a difference of 30 days instead of 60. You will notice there is
no mention of 30 in the formula. I've gone back to the confirmation letters
that printed out from this query, and they are all correct until the one I
sent out today (the first one I've sent out since the update), but the values
in the query are now incorrect. It looks like all the From dates are in
December through February, where the calculation is incorrect.
producing an incorrect answer intermittently:
Due Date: [From
date]-IIf([Country]="",IIf([nights]>20,90,60),IIf([nights]>10,90,60))
In most cases the calculation is correct, but about once in 5 cases, it's
calculating a difference of 30 days instead of 60. You will notice there is
no mention of 30 in the formula. I've gone back to the confirmation letters
that printed out from this query, and they are all correct until the one I
sent out today (the first one I've sent out since the update), but the values
in the query are now incorrect. It looks like all the From dates are in
December through February, where the calculation is incorrect.