To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108590 Issue #|108590 Summary|In SRB MAX() MIN() functions two days off Component|Database access Version|OOO310m19 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|eremmel
------- Additional comments from [email protected] Fri Jan 22 21:26:20 +0000 2010 ------- When I create a report with SRB and want to have the MIN or MAX value of a date field I can create a function in two ways. One is by hand using the code like: name : MaxD initial : [D] function : MAX([D];[MaxD]) The result of this function is two days too less, the same applies to MIN() One can also create implicit a MAX function by adding a formated field and select the Date tab on the properties. One can select 'Date Field Type': 'Function' and 'Function' : 'Maximum'. This function is constructed like: name : MaxD initial : [D] function : IF([D]>[MaxD];[D];[MaxD]) This goes OK. When one wants to work with a simple 2-value max the latter is a fine alternative, but with more than 2 values it becomes complex. See the attached document for more details and run Report 'Q'. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
