nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Birt changes date retrieved from database

Elja

Hello.

We just noticed that Birt changes in certain cases the date field value in the report.
 
For example:
If the date in the field named "sulkemispaiva" is in format '2015-04-20 23:59:59.999' in the database, it is shown as April 21, 2015 12:00:00 AM in Birt.
 
I was using a different time format (showing only the date). After changing format datetime to style showing also the time (12. October 2015 16.27.31 UTC+3), I noticed that whenever the time stamp of the field is 23:59:59.999 Birt (I guess) rounds it up to the next day 12:00:00 AM.
 
How can I "tame" BIRT and keep the date as it is in the database? Only date is relevant in this case, not the time..
 
Thanks in advance, Elja

Find more posts tagged with

Comments

JFreeman

What version of BIRT are you using?
 
The first thought I have to get around this behavior is to change the date column into a string column. Then create a computed column to manually create the desired date value by dropping the time and just providing the desired date from the string into the new date object.

Elja

Hei Jesse.
I'm using Eclipse 4.5.0 (and to my acknowledge thing Birt goes along with that version-wise).

I'll look into your suggestin, thanks!
 
- Elja

Elja

Hi.
 
Jesse's suggestion worked (although I didn't use computed column, but data-field).
It's a peculiar thing that BIRT rounded up the date in the first place...
 
But: the solution for me worked as follows:
1) I changed the type of the existing "closing_date" from date to string.
2) I moved the "closing_date" field into a new column in the right side of the table
3) I created a new Date-typed data -field "cl_date" into the spot where I moved the "closing_date" from.
4) I copied the value from the old "closing_date" to the new "cl_date":
row["closing_date"]
5) I used the Properties - Format DateTime for cutting out the time -stamp and formatting (Custom - Finnish and format code: d.M.y) for pulling out just the date and in correct format.
6) After verifying that the date is now presented as it is in the database, I hid the old "closing_date" value (column -> visibility -> Hide element).
 
And now I've tamed the date!
 
- Elja

JFreeman

Thank you for providing the full details of your solution.
I'm glad that worked out for you.
 
Let us know if you have additional questions.