[Solved] Wrong date in Report

[smedens]

I'm trying to create a report from a few different tabels. The thing is - when i create the report the column with dates is displayed totally wrong. Where there are supposed to say dates like 1999-01-31, 2001-05-17 etc, it says random numbers like 36815 and 35917(all 5-figures)!!!
The datatype chosen is DATE and i've chosen a date format aswell. In the designview the dates are displayed correctly.

Anyone has a clue of what i've done wrong?

[Villeroy]

The numbers are not random. Try again to change the number format. Open the report for editing. If it is a Writer table select the date cell under the label row and apply any number format of category "Date".
If it is a set of form controls as created by the Report Builder Extension, Ctrl+Click the box then find the number format property or replace the box with a date control.

[r4zoli]

You not doing wrong, may be you use not correct version of ORB, the OOo 3.3 require ORB 1.2.1-rev, dated 2010.12.14.
This works for me under win7 and linux correctly, I can not reach Mac for checking it.

[smedens]

Thanks!

I managed to get it right =) By selecting the "datecolumn" and clicking och "number formatting"... Never tought this would be something that is not handeled automatically? I mean I've already chosen format in an earlier stage!

Anyhow, thanks alot!