Date loaded from table into header is 1 day short
Date loaded from table into header is 1 day short
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?
Open Office 4.0 on Win 7
Re: Date loaded from table into header is 1 day short
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?
Open Office 4.0 on Win 7
Re: Date loaded from table into header is 1 day short
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.
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.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin