Date Result Varies

[Drunkenneo]

this is lot to ask, but i have to as i searched all the forums for idea.

I have a dateTravel field in table Datatype "dd/mm/yyyy", which is populate from the form textbox, having long date format.

I have to check duplicates before writing to table which i made a statement:

int1 = DCount("*", "tblDataentry", "(([tblDataentry].[dateTravel] =#" & d & "#)

yesterday was working fine but today not fetching duplicate, i have tried using format also but result varies from day to day. Help Needed.

 

[Mihail]

This thread on Bytes forum is a good start in handled date data. Also you will find another link in that thread. I advice you to follow it as well.

 

[namliam]

What probably already is said in the link, in code the date needs to be in MM/DD/YYYY format, regardless of what your date "looks like" in your table.

 

[Mihail]

Indeed. But the cascade links explain how to obtain this format in various situations. And contain useful examples.