Date Problem

[Kaspro via AccessMonster.com]

Hi all...i have a small date issue which is i have a textbox used to search
in my database using date, and i'm using a "shortdate" input mask for the
textbox, but the problem is that i have to start the date with month/day/year
to perform the search and what i need is to start with day/month/year,
despite that the database result always appears with day/month/year format,
so i dont know what to do?!!!
Thanks alot!

 

[June7 via AccessMonster.com]

You must have your computer Regional settings using the day/month/year
configuration?
Hmmm! Try using the Format function. Here are some links:
http://forums.devx.com/showthread.php?t=70057
http://www.vb6.us/tutorials/formating-dates-and-times-vb6

Are you in the U.S.? Might consider changing the Regional setting and
modifying your data.
http://www.tech-archive.net/Archive...c.access.tablesdbdesign/2008-05/msg00364.html

 

[Kaspro via AccessMonster.com]

What's really annoying is that everything is set to "dd,mm,yyyy" and in my
regional setting too and in my access forms also appears as "dd,mm,yyyy"
except when i'm searching i have to enter it as "mm,dd,yyyy" which is very
wierd!!!!
and here's all the setting and how i search:
for the date textbox the format is set to "short date"
and the input mask is set to to "short date" too
and here's the sql statment
"SELECT * FROM Expenses WHERE Date = #" & Me.txtDate.Value & "#"
so i dont know what's going wrong?!

 

[Kaspro via AccessMonster.com]

I think i got a way around this problem....i used the Format functions to
format the date which is entered by the user to the date that is stored in
the database like this:
Format(Me.txtDate1, "mm,dd,yyyy")
Coz i think the problem is that how's the date is stored in the database and
i think its working fine now!

 

[Kaspro via AccessMonster.com]

I think i got a way around this problem....i used the Format functions to
format the date which is entered by the user to the date that is stored in
the database like this:
Format(Me.txtDate1, "mm,dd,yyyy")
Coz i think the problem is that how's the date is stored in the database and
i think its working fine now!