Update SQL

[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

 

[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]).