We are trying to achieve date values in prompt level in descending order. When we select the period type from the prompt as per user input like “Year or Month”, then the period values should show with respect to the period type selection in proper descending or ascending order. We are not able to sort the date column in prompt level in the proper descending order even though we have applied the logical sql for the date column as sort descending. The date prompt is showing in-proper order.