How to query by date for Access database?

There are two fields "Поле47" and "Поле49"where you enter the date. You need to select from the table "Technical documentation" all records in the range of these dates. Here is the query:
StrSql = "SELECT * FROM [Technical documents] WHERE [Technical documentation].Datarates >= #" & Me.Поле47.Value & "# and [Technical documentation].Databases <= #" & Me.Поле49.Value & "#;"
 Set qdf = db.CreateQueryDef("gen_a_report", StrSql)
 DoCmd.OpenQuery "gen_a_report", acViewNormal

But displays an error

The data input range is.
March 23rd 20 at 19:08
1 answer
March 23rd 20 at 19:10
The format of the date check needs to be: yyyy-mm-dd
Is the short date format here and there - Shany90 commented on March 23rd 20 at 19:13
Thank you
Format(Me.Поле43.Value, "yyyy-mm-dd")
given the result. - Shany90 commented on March 23rd 20 at 19:16

Find more questions by tags Microsoft Access