SQL String

[damo]

Ive a problem picking dates up from a form directly into an SQL string (a report is based on this string).
It's a between 2 dates report, and for some reason both dates are giving errors if the date is > 27/09/2000.
Ive used this type of this type of thing before in building SQL strings but have never came across this problem.

Any solutions most welcome at

andrew.hart@finance.glasgow.gov.uk

 

[accesswatch]

If you are building your string in VBA then
This is a Known problem ('bug') with Concatenated DATES in SQL Strings in VBA.
Dates must be in American format under these circumstances.

See my reply to the posting 'SQL in VBA' on this forum

Note: This only applies to dates in SQL strings in VBA
Hope this helps
trevor from www.accesswatch.co.uk

[This message has been edited by accesswatch (edited 09-12-2000).]

 

[Ron Bell]

Had this problem today!!

Use x = Format("x","mm/dd/yy")
then use x in yr SQL