Date Range Interactive report
I have an interactive report
I want to include
where dte between to_date(:p38_from_date,'mm/dd/yyyy') and to_date(:p38_to_date,'mm/dd/yyyy')
I have 2 date pickers and they both format 'mm/dd/yyyy' I can not get this to work
Above what I am doing here is i want to include a NVL on each date parameter in the SQL statement.
nvl(:p38_from_date, '01/01/2009') and '12/31/2050'
I have looked at this forum extensively and I may be a little thick when it comes to dates in apex.