🚀 go-pugleaf

I'm trying to use the criteria of the following xbase command in a SQL query
...

set filter to expir>{01/01/99} and expir<{01/01/02}

As written above, the statement works fine, showing records with expiration
dates both in the final year of this century and into the next.

My SQL version of this, however, doesn't work, returning no records at all
...

select * from mytable where expir>"01/01/99" and expir<"01/01/02"

What puzzles me is that ...

select * from mytable where expir>"01/01/99"

does return the records I'm looking for (without the outer-range limit),
both in this century and the next.

I tried "SET EPOCH TO 1930" but that had no effect. As usual I've run out of
ideas fast. Thanks for help.