Dlookup Date Format Issue

[AndrewKent]

Hi there, I am having difficulty with a DLookup. I want to look at the date in one table, and return a value from another table based on said date. This is what I have so far:

Leaving Date: DLookUp("DateMatrix_Date","tblMatrix_DateMatrix","DateMatrix_Date = #" & [SDB_EndDate] & "#")

Problem is that although the fields in both tables are the same, If the lookup value is "03/09/2010" the Dlookup is returning the value for "09/03/2010" first.

How can I fix this?

Andy

 

[SydneyGeek]

Convert the date to a long integer. That makes it unambiguous.

Leaving Date: DLookUp("DateMatrix_Date","tblMatrix_DateMatrix","DateMatrix_Date = " & CLng([SDB_EndDate]))

Denis