dlookup() with date

[markjkubicki]

maybe there's a small nuance I'm missing when using DLookUp with a date as the criteria...
my DMax returns correctly
I do not get an error with my DLookup
BUt the DlookUp retuns the wrong value...

perplexed.. (but with thanks in advance for any assistance), mark


vMaxDate = DMax("[Version_Date]", "tblVersionInfo")
vlblVersion_Info = DLookup("[Version_ID]", "tblVersionInfo", "'[Version_date] = " & vMaxDate & "'")
Me.lblVersion_Info.Caption = vlblVersion_Info

[JoeM]

If it is a true date, you need to surround it with pound signs (#6/25/2012#).
See here: http://www.techonthenet.com/access/f...in/dlookup.php

[ssanfu]

Dates and strings (text) need delimiters. Strings use single or double quotes, while Dates use the hash (#).

Try

vlblVersion_Info = DLookup("[Version_ID]", "tblVersionInfo", "[Version_date] = #" & vMaxDate & "#")

Expanded: " [Version_date] = # " & vMaxDate & " # ")

[markjkubicki]

thnx !!

mark