P
Paulo
I have the calculated field below in a query. I was expecting to get the
results in the query (for this field) formatted as a date. But this is not
happening. Can anyone explain why, and suggest solutions?
Thanks in advance,
Paulo
Relevant_Date: IIf([Payment Terms]![Counting
From]="Shipment",IIf(IsDate([Orders]![Ex-Factory2]),CDate(DateAdd("d",[Payment
Terms]![Payment Days],[Orders]![Ex-Factory2])),""),IIf([Payment
Terms]![Counting From]="Invoice",IIf(IsDate([Orders]![DC Received
Date]),CDate(DateAdd("d",[Payment Terms]![Payment Days],[Orders]![ETA to
DC])),""),IIf([Payment Terms]![Counting
From]="Delivery",IIf(IsDate([Orders]![DC Received
Date]),CDate(DateAdd("d",[Payment Terms]![Payment Days],[Orders]![DC Received
Date])),""),"")))
results in the query (for this field) formatted as a date. But this is not
happening. Can anyone explain why, and suggest solutions?
Thanks in advance,
Paulo
Relevant_Date: IIf([Payment Terms]![Counting
From]="Shipment",IIf(IsDate([Orders]![Ex-Factory2]),CDate(DateAdd("d",[Payment
Terms]![Payment Days],[Orders]![Ex-Factory2])),""),IIf([Payment
Terms]![Counting From]="Invoice",IIf(IsDate([Orders]![DC Received
Date]),CDate(DateAdd("d",[Payment Terms]![Payment Days],[Orders]![ETA to
DC])),""),IIf([Payment Terms]![Counting
From]="Delivery",IIf(IsDate([Orders]![DC Received
Date]),CDate(DateAdd("d",[Payment Terms]![Payment Days],[Orders]![DC Received
Date])),""),"")))