Apache OpenOffice Community Forum

I have a query that picks up a date from a field in a table, and a report that displays the date in the report Header. When I run the report, the date shows correctly when the report first appears in Writer, then a couple seconds later the date sets back one day. Another field that has TODAY() as the variable was doing the same thing until I changed it to int(TODAY()); now it stays at the proper date. But I couldn't use the INT( ) function with a field out of a table. This setback does not occur if I put the same field in the Detail section of the report; the date stays correct. What is wrong with the header date field?

further note - I had a page counter displayed in the page footer, "Page # of #". When I don't have the "of #", that is the PAGECOUNT() function involved, the date in the header does NOT change. Any explanation, or is this a bug?

What version of OOo you uses?
I assume that you use SRB/ORB, which version? The similar error happened in earlier version of SRB, which was fixed.
Use OOo 3.3 with ORB 1.2.1-rev2.