Add any date column in criteria, go to column properties > data format > Override default Data format >Custom Date Format . Give the format as DD-MON-YYYY here.
The Save as Default > System Wide Default for this data type.
This will make the format for all Date datatypes as DD-MON-YYYY .
Edited by: Maqsood Hussain on Dec 3, 2012 11:04 PM
Thanks for your reply , i know this procedure as we do this at report level , but i am asking on how to do this at rpd level as we want the values of dates in filters or prompts to be displayed as 'DD-MON-YYYY' format , the procedure suggested by you will show results in answers but not in filters/prompts.
Please suggest me the procedure on how can we achieve this at rpd level.