title: How to change date format (month name) in iReport?
body: <p>I've a requirement to change the date format in iReport.
  Currently I used an SQL query to collect the data.
  Here's my query in iReport</p>
  
  <blockquote>
    <p>SELECT DATE_FORMAT(CURRENT_DATE,'%d-%m-%Y') AS currentDate, Upper(e.name) AS name , e.address, 
    Upper(ea.comName) AS comName blablablabla.....</p>
  </blockquote>
  
  <p>and currentDate field will show 28-12-2011</p>
  
  <p>What the requirement is change the month (12) to "Disember" not "December". Or if the month is 1 so in the report should be "Januari".</p>
  
  <p>The Month names are [Januari, Februari, Mac, April, Mei, Jun, Julai, Ogos, September, Oktober, November, Disember].</p>
  
  <p>Can I do these condition in iReport?</p>
  
  <p>Thanks in advance.</p>