date format in vb and access 1

[daveask]

Hi Experts,

My VB code for getting data from Access database:
myDate = Date()
strSQL = "Select * From Table1 Where [Date] = #" & myDate & "#"
Sometimes this got problem because of the date/time format in Access: mm/dd/yyyy or dd/mm/yyyy.
How to make sure the code is always correct no matter what date/time format is in Access?

Thank you in advance.

 

[thornmastr]

If I remember correctly you must use the standard American date mask of #mm/dd/yyyy##.

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@earthlink.net

 

[bjd4jc]

The other thing to keep in mind is that you must use the Date/Time data type in your Access field. Otherwise this will not *always* be successful.

 

[ClulessChris]

Daveask
Try:

myDate = sFormatedDate = Month(date()) & "/" & Day(date()) & "/" & Year(date())
strSQL = "Select * From Table1 Where [Date] = #" & myDate & "#"

Everybody body is somebodys Nutter.

 

[hansu]

You could also use Format$:

strDate= Format$(myDate, "\#mm\/dd\/yyyy\#")
strSQL = "Select * From Table1 Where [Date] = " & strDate & ""

 

[daveask]

Thanks a lot for all your responses, I will try.....