Member Avatar for jaasaria

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
  • 93 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by awny56
Member Avatar for steve585

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

Member Avatar for jaasaria

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.

Member Avatar for cometburn

mySql Date Format is: Year-Month-Date

which is YYYY-MM-dd

Member Avatar for steve585

Did you solve the problem?

Member Avatar for awny56

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

Best Regards
Eng.Awny

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.