0

hi guys... i have an urgent problem please give an idea about it..


Question#1: I want to know the correct date syntax in query database using MySQL...
Question#2: I currenly using the MySQL connector/OBDC 3.51 is their any problem about it??


thxx in advance.... and ned asap reply...
thxxxxxxxxxxxx guyzzzzz..

4
Contributors
5
Replies
6
Views
9 Years
Discussion Span
Last Post by awny56
0

Please be more specific:
how do you want to use date syntax?

i want to use the date syntax in my related form and also to my reports. i want to use date as a filter condition on my database MySQL using the 2 txtbox that hold the date value. One txtbox hold the (starting date) and the another txtbox hold the (ending date value).

i have also problem with the "access denied error" that i think is a MySQL bug.

0

SQL="SELECT * From Table Where DATE Between #" & Format$(Startdate, "YYYY-MM-dd") & " # and #" & Format$(Enddate, "YYYY-MM-dd") & " #"

Best Regards
Eng.Awny

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.