[Solved] Retrieving Date Prompt Values

[jimmyco23]

Good Morning,

I would like to retrieve the date prompt values that a user selects so that I can use these values to filter my queries.

For example, if a user selects a start date of 11/1/2014 and an end date of 12/15/2014, I would like to filter my queries on the dates 11/1/2014 and 12/15/2014.

I am aware that you can take certain data items and filter them in range, i.e. "[RecordCreateDate] in_range ?DatePrompt?. Instead, what I want to do is get records with a record create date of 12/1/2014 - 12/15/2014, and that requires me retrieving the 12/15/2014 date prompt value.

Thank you for your help.

[cognos810]

Hello Jimmyco23,
Not sure if I got your problem correct, but if I did....
You will need to break your date prompt into two. Create a data prompt for begin date and assign a parameter to it, lets call it ?BeginDate?, then create another date prompt and assign another parameter called ?EndDate?.
Then in your query apply the filters using the parameters ?BeginDate? and ?EndDate? as needed.

-Cognos810

[jimmyco23]

Thank you!