date not showing properly

Hello

I'm using this to query date in my db (MySQL)

DATE_FORMAT(FROM_UNIXTIME(invoice_date), '%Y-%m-%d') AS invoice_date

But in the layout, if I put the column invoice_date to the report design and test view it, why is it not showing the full string?
The date is just showing 2009 not 2009-11-07

If I try to create a report from the sample db (ClassicModels), the date showed properly.

What am I missing here?

Find more posts tagged with

Comments

mwilliams

Hi strikenoir,

What format is your date in you database in originally? Could you just bring in your date and format your date through BIRT instead?

strikenoir

Dear Michael

Thank you for the previous help

I have solved this problem, it seems the format that BIRT accepts are YYYY-MM-DD

I wasn't using that format.

Thank you again

mwilliams

No problem. Glad you found a solution!