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
Fetch Data based on Date Range input
Migrateduser
<p>I have a report with one of the columns as Payment Date.<br><br>
I have to receive search parameter in the form of JSON where a date range will be there - start_date and end_date.</p>
<p>I need to show the data where Payment Date falls in the given date range.<br><br><strong>How do I write the script in beforeopen ?</strong></p>
<p> </p>
<p>Right now I'm hardcoding a json like :</p>
<p>jsonStr = "{\"start_date\":\"2013-01-01\", \"end_date\":\"2013-06-30\"}"</p>
<p>I'll parse the JSON and take out the values from both the keys(start_date and end_date).</p>
<p> </p>
<p><strong>How to use these to fetch the data as per the given date range?</strong></p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet