Oracle Data Extract - Filter by date

[markwrosslee]

I am connecting to a Oracle Database via Discoverer prepared MISS (Data extract reporting tool). There are over 41 million records and want to filter these but date - TRANSACTION_DATE > 2017/12/31 23:59:00 but this yields no data fulfilling the criteria. Have added ('2017/12/31 23:59:00; YYYY/MM/DD HH:MM:SS') but still no results.

[jheasley]

I use Variables and loops to do my Oracle date limitations. this example looks back to the beginning of 2 years ago, and looks to the end of the current month.

LET vMinDate = Date(AddYears(YearStart(vEndDate),-2),'YYYY-MM-DD');
LET vMaxDate = Date(MonthEnd(vMinDate) + 1,'YYYY-MM-DD');

WHERE "DATE_FIELD_GOES_HERE" >= TO_DATE('$(vMinDate)','YYYY-MM-DD') AND "DATE_FIELD_GOES_HERE"< TO_DATE('$(vMaxDate)','YYYY-MM-DD');

[markwrosslee]

Afternoon thank you and i have taken a snap shot of the filter input i need assistance on - any suggestions as i don't want to load all the date as it is some 42 million lines. You can also see the date format i need to filter. Regards