title: How to change the date format in Oracle BI Publisher?
body: <p>How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy format. I am not able to locate where the format option exists in BI Publisher. The BI Component I am using is PivotTable.</p>
  
  <p><img src="https://i.stack.imgur.com/FAy49.png" alt="enter image description here"></p>
  
  <p>The problem with order:</p>
  
  <p>Although, I have ordered my data in the data model, still the data is not showing up in the proper order in the chart. The same thing is working fine on the data table. See below -</p>
  
  <p><img src="https://i.stack.imgur.com/OfDsZ.png" alt="enter image description here"></p>