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.

[pbaldy]

http://allenbrowne.com/ser-36.html#Format