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
How to have the inputs for StartDate and EndDate in SQL?
Migrateduser
I have Report Parameters (StartDate and EndDate), and I want these 2 inputs inside the SQL. I tried below, but does not work.select SYSTEMTYPE_ABC, TIME_STEP, TIME_SYSTEM, LASTUPDATEfrom table_XYZwhere (SYSTEMTYPE_ABC like ?) and (LASTUPDATE BETWEEN like ? AND like ?)What the correct syntax?thanks.
Find more posts tagged with
Comments
There are no comments yet