How to query by date in Access database?

Question

Microsoft Access

There are two fields " Field47 " and "Field49" in which the date is entered. You need to select from the table " Technical documentation " all records in the range of these dates. Here is the request:

StrSql = "SELECT * FROM [Техническая документация] WHERE [Техническая документация].Дата_разноса >= #" & Me.Поле47.Value & "# and [Техническая документация].Дата_разноса <= #" & Me.Поле49.Value & "#;"
    Set qdf = db.CreateQueryDef("gen_a_report", StrSql)
    DoCmd.OpenQuery "gen_a_report", acViewNormal

But it throws an error

Mistake

There is data on the input range.

Answer 1

Check the date format, should be: yyyy-mm-dd