Between Two Dates criteria in Visual Query Builder

[crtakacs]

I'm sure this has been answered but I can't seem to find it specific to my question. 

i would just like to have criteria in the Visual Query Builder that identifies between two dates. 

This is what I have for it to identify date for one specific day:

= To_Date(SysDate - 2)

But I would like it to match data that is between 'SysDate - 2' and SysDate - 1'

[danilang · Accepted solution]

Hi @crtakacs 

When you're targeting Oracle, you can use the Between operator

BETWEEN TO_DATE(SysDate-2) AND TO_DATE(SysDate-1)

Dan