DLookup for dates (1 Viewer)

[boblarson]

Glad you got it working.

 

[obeylele]

I was doing the same thing and stuck with this strange problem. your post made me realize it was a problem with date format and I did not have option to change systems date format. So used VB's Format function to change the date format. Just in case anyone needs to do that.

holDate = Format(holDate, "m/d/yyyy")

 

[Andrew Thorpe]

Many thanks. I'll give that a try. Much appreciate your advice. Regards, Andrew