smart quotes in your example - and a mismatched paren
your date format is not quite right (3 characters for month)
q: "14 sept 2021" as date
E: This expression could not be parsed.
q: "14 sep 2021" as date
A: Tue, 14 Sep 2021
I: singular date
time issued gives a Time object, so the string comparison will not quite work
If you convert the Time object to a Date, you can then compare
Try this slightly modified query?
(ids of it , names of it, times issued of it, targeting relevance of it) of bes actions whose ((name of it starts with "RedhatPatching") and (time issued of it as local date = "14 sep 2021"as date | False))