Find date

[Jason]

I have a lookup for current date and next date using findfirst and comparing
with today.
In the forms the dates are displayed as short date (dd/mm/yyy). There are
dates for today but the code is not finding the dates. I've tried using hash
(#) before and after the date but still nothing found.

Thanks,
J.

 

[Stuart McCall]

I have a lookup for current date and next date using findfirst and
comparing with today.
In the forms the dates are displayed as short date (dd/mm/yyy). There are
dates for today but the code is not finding the dates. I've tried using
hash (#) before and after the date but still nothing found.

Thanks,
J.

Access requires searches on dates to be in US format, so try:

rs.FindFirst "MyFieldName = #" & Format("MyDate", "mm/dd/yyyy") & "#"

 

[Jason]

I remember having this problem a lot. When dealing with date comparisons
I've had to use something like clng(DateFld1) comparison clng(DateFld2).
Surely I shouldn't have to do this!

 

[Douglas J. Steele]

Check Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003 Access
Answers column for Pinnacle Publication's "Smart Access" newsletter. (The
column and accompanying database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)

 

[Jason]

I thought access interpreted the date properly when using that layout.
Obvious now that it has to use the us format. I'll probably stick to what I
am using since this coding has already been done.