John Big Booty
AWF VIP
- Local time
- , 10:39
- Joined
- Aug 29, 2005
- Messages
- 8,262
I'm having trouble with DLookup() using dates as part of a multiple criteria. I'm using the following;
It seems that if ShipOBDate is any date between the first and tenth of the month the DLookup fails to locate the appropriate record. I can't understand why as ShipOBDate and ExchDate are both formatted as Short Date and ExchDate is being populated via an OpenArgs which is derived form the field ShipOBDate :banghead:
Is the fact the the date is getting converted from a date to string and back to a date some how upsetting things
Code:
If IsNull(DLookup("ExchRate", "TBL_DDPExchRates", "CurID = " & Me.Combo4 & " AND ExchDate = #" & Me.ShipOBDate & "#")) And Me.Combo4 <> 2 Then
Is the fact the the date is getting converted from a date to string and back to a date some how upsetting things