sql and dates (2002)

Topic

New Reply

Hi all,
i know this must sound stupid. im trying to run an sql line in code. im putting a date in the sql string.
the date is formatted dd/mm/yyyy just like the field its corresponding to.
This is the end of the string

((tblSection6.Period)=” & “#” & Format(PDate, “dd/mm/yyyy”) & “#” & “));”

doesnt seem to like it. anyone help me out?
it just returns no recs when i know there are some there

Reply | Quote

Replies

I believe that dates must be in format mm/dd/yy if you are going to embed them (that is, surround them with #…#). Not 100% sure on this, though.

Reply | Quote

Mark is correct, dates MUST be in US date format in SQL, i.e. mm/dd/yy or mm/dd/yyy.

By the way, you can simplify the expression to

… tblSection6.Period = #” & Format(PDate, ” mm/dd/yyyy”) & “#)”

Reply | Quote