To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70081 Issue #|70081 Summary|Query Designer incorrectly determins return type for D |atediff function Component|Database access Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Tue Oct 3 13:40:22 -0700 2006 ------- It is not possible to construct a query with a criteria similar to SELECT ...... where datediff( 'dd', CURRENT_DATE, "aDateColumn" ) <= 30 AND "aDateColumn" > CURRENT_DATE A select statement with this criteria is acceptable in SQL view with escape pocessing turned on, but in designer view an error is issued that the data type is incorrect for the datediff column. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]