variable date in a query

[atrium]

I want to include a variable date in my query WHERE condition.

Not sure of the right syntax

 

[Deleted member 147267]

Not enough info to even begin answering.
Where will/does the date come from - a form control?
Or is this about a report?
I could go on with several more questions but will leave it to you to provide some background/insight as to what you are doing.
Or you could simply research "concatenation" and learn how to do it and apply it to your situation.

 

[theDBguy]

How do you mean a "variable date?"

 

[CJ_London]

ensure date is in us format of mm/dd/yyyy and surround with # characters e.g.

WHERE myDate=#05/15/2020#