Problem with Format(Date) in SQL statement

Hello

I am having some problem comparing dates with the SQL statement below


MySQL = "SELECT Format(Date, 'yyyy/mmmm/dd') as [Expr1] FROM TblDates WHERE
_
Format(Date, 'yyyy/mmmm/dd') = #2006/April/18#"

Even though the date 2006/April/18 is in TblDates, it is never found by the
above SQL statement

Anyone know why?


Thanks

G Gerard


.

Relevant Pages

  • Re: Problem with Format(Date) in SQL statement
    ... G Gerard wrote: ... I am having some problem comparing dates with the SQL statement below ... Even though the date 2006/April/18 is in TblDates, it is never found by the above SQL statement ...
    (comp.databases.ms-access)
  • Re: Counting days in a crosstab query
    ... How would those two fields fir into the sql statement you created. ... "Duane Hookom" wrote: ... > The SQL view of the query should be: ... > FROM tblDates ...
    (microsoft.public.access.reports)
  • Re: Nearest max date before a specified one
    ... SELECT Maxas MaxDate ... Frank wrote: ... > I am trying to create an SQL statement which would return to me the maximum ... > FROM R tblDates ...
    (microsoft.public.access.queries)
  • Nearest max date before a specified one
    ... I am trying to create an SQL statement which would return to me the maximum ... FROM R tblDates ... Frank ... Prev by Date: ...
    (microsoft.public.access.queries)