Update SQL

J

JIT

I am getting an error statement that I have a data mismatch in the criteria
expression. Can anyone tell me where it is?


IIf(DateDiff("d","Arrival Date",[Start Date])>CLng([Rates]![Free
Days]),(Date Range Detention Query_1]![Departure Date]) Or
IIf(DateDiff("d","ArrivalDate",[Start Date])<CLng([Rates]![Free Days]),(("Max
Charge Days Total")-CLng(([Rates]![Free Days])-(DateDiff("d","Arrival
Date",[Start Date])))))


thank you,

JIT
 
L

Lynn Trapp

I've already answered this in another newsgroup, but basically DateDiff
requires 2 dates as it's arguments, but you have one string ("Arrival Date")
and one Date ([Start Date]).
 
Top