There are two ways to go. First you can always use a parameter to input the date. However, it would seem if 3 days is always the case then there is another solution.
HSQL embedded (Base default) is very restrictive when dealing with SQL and even more so with date math. It is old and is in the process of being replaced by Firebird. The best thing to use with this (and works on newer HSQL databases) is
Select DATEDIFF('dd', "YOUR_FIELD", CURDATE()) FROM "YOUR_TABLE WHERE DATEDIFF('dd', "YOUR_FIELD", CURDATE()) = 3
Now my comment mentioned what DB you are using. This same statement in MySQL is:
Select DATEDIFF(CURDATE(), "YOUR_FIELD" ) FROM "YOUR_TABLE" WHERE DATEDIFF(CURDATE(), "YOUR_FIELD") = 3
Of course these samples only select the number of days different between the dates. You would of course select other fields but the WHERE statement is consistent.
If this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.