date with a query

  • Thread starter Thread starter tony
  • Start date Start date
T

tony

hi

i try to build a query with date



in my table i have 2006-03-29 (yyyy-mm-dd)

i tried

select * from test3
where jour = "2006-03-29"

and

select * from test3
where jour = '2006-03-29'

i got: bad type into the expression....

any idea?

thanks
 
If this is a date/time field in an Access table, try:
select * from test3
where jour = #2006-03-29#;
 
hi

i try to build a query with date

in my table i have 2006-03-29 (yyyy-mm-dd)

i tried

select * from test3
where jour = "2006-03-29"

and

select * from test3
where jour = '2006-03-29'

i got: bad type into the expression....

any idea?

thanks
Click to expand...

What is the datatype of [jour]? Date/Time?

select * from test3
where jour = #03-29-2006#

Note the use of the # date delimiter symbol and the fact that
regardless of your computer's regional data format, it must be written
in US month day year format.
 
Back
Top