Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Optional Date Range Parameters
Migrateduser
<p>Hi All! Forgive me if this is already posted somewhere but I searched and searched and couldn't find the answer to what I'm trying to do. What I have is a simple date range (From Date and To Date). In the select portion of the SQL I have defined the date as to_char(doc_dt, 'MM/DD/YYYY') and have it set up in the where clause as "to_char(doc_dt, 'MM/DD/YYYY') between ? and ?". I did the to_char here because I want the user to be able to enter their desired date into the parameter field in that format. (If there's a better way to do that, please let me know!) So the issue I am having is that both of those dates are optional and if the user decides to leave them both blank then I want to return all of the data. Right now, if I leave them both blank I don't get any data back. Any ideas on how to handle this?? Thanks so much for any advice you can provide!</p>
Find more posts tagged with
Comments
There are no comments yet