Forum Discussion
Dynamically Filtering TRUNC(SYSDATE) - 1 Without Breaking Query Folding
I have read several questions related to filtering dates without breaking query folding, but none seem to help with my issue. In Oracle I would write: DateColumn BETWEEN TRUNC(SYSDATE, 'YYYY')...
Just break it up into two separate steps.
Of course, the surest way is always to use a query for your variables, so Query1 is the first day of last year, Query2 is Today's date, and your statement would be
each [Date] >= Query1 and < Query2
--Nate