This content has been marked as final. Show 5 replies
You can go for SQL query or some values at 'Default to' in the prompt. This should work.
Are you expecting something else?
If helps mark
What is the sql query for that requirement.
That should be something like1 person found this helpful
SELECT MONTH FROM "Service - CRM Service Requests" WHERE Time.Date BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-3, current_date) AND TIMESTAMPADD(SQL_TSI_MONTH,-1, current_date) ORDER BY saw_0
So in each filed you have to put
Hope this helps, update back
Edited by: Srini VEERAVALLI on Feb 20, 2013 12:37 PM
How to display 2013 JAN instead oj 201301 for my previous query
try to change the data format like YYYY MMM in comumn properties