Date math in HSQLDB embedded is difficult at best. You could try this method by @pierre-yves samyn in this post -> How to do basic arithmatic with dates in Libre Base queries using current_date. Have just tested and works but you must then also account for changeover in months.
Select current_date -1 from "Table_name"