sort a drop down list

[lporter@wsutech.edu]

I want a dropdown list of dates to display latest to oldest but can't see where I can do that.

We are using 11.0.7 Cognos Analytics. I'm new to Cognos but have IR and relational database experience.

[CognosPaul]

Once you attach a query to the value prompt you should see a "Sorting" row in the properties. Doubleclick on that and you can define the sorting however you want.

[lporter@wsutech.edu]

Sorry, I'm not getting it, maybe attachment will help, thank you.