You can use "Add Time to Date" workflow action, please see example below:

Also maybe you have a look at 3rd party solution Plumsail Workflow Actions Pack for Workflow Designer that contains Get Items by Query workflow action, that can query items by defined CAML expression.
P.S: This one from products are developed by my team.