hi

i am having a date problem in vb. i am using access as database.
i am using dd/mm/yy format in my project.but in access date are stored in mm/dd/yy format.

my database structure is like this-
filename  text
start_dt  date
end_dt    date

if i provide a date then according to logic it checks like this

if strdate >=start_dt and strdate <=end_dt then
    show filename
end if

but this code is not working
someone please help me.

Check your regional settings
sounds like they are not british english.

Put the date in rs.fields("Start_dt") = format(now,"dd/mm/yyyy")
will work but when you retrieve the data access thinks it is formatted "mm/dd/yyyy"

so the 1st of may input would be retrieved as the 5th of january

I'll get back as soon as ive checked this

just checked it and that would seem to be youre prob.

Happy Hunting

(For future programs),

I've always found entering and storing the date in the full longer format better (ie: Jan 01 2002). That way there's no problem telling which is which, no matter what order they're in.

Especially when dealiing with numerous date formats (over 10) in one building of users. Especially when Access had an interesting habit of changing the date structure when opened on the different PC's and storing the dates in different formats based on the user's preferences. Values stored by one user (by opening the Access DB directly) showed up on every else's PC as being entered in 1906.