title: Formatting Date Time in BIRT Reports
body: <p>I have an issue working with date time in BIRT Reports.  All I want to do is given a date time, from either a Report Parameter, Date Time column in a data set, or even using new Date() in some java script, I want to format the value using local time.</p>
  
  <p>So given the date as 2011-06-25 23:00:00 (which is always stored in universal time), I want to format it as 2011-06-26 00:00:00 BST (as I am running in UTC Dublin, Edinburgh, Lisbon, London timezone.</p>
  
  <p>Using the built in Format DateTime settings the closest I have come is formatting 2011-06-25 23:00:00 in the Report as 2011-06-25 23:00:00 GMT.</p>
  
  <p>I have posted this on the <a href="http://www.birt-exchange.org/org/forum/index.php/topic/22979-formatting-date-time-in-local-time/" rel="nofollow">BIRT Exhchange forum</a> also so hopefully someone can help.</p>
  
  <p>Any ideas?</p>
  
  <p>Cheers,</p>
  
  <p>Andez</p>