https://bugs.freedesktop.org/show_bug.cgi?id=79886
Priority: medium
Bug ID: 79886
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: standard filter problem in date with hours
Severity: normal
Classification: Unclassified
OS: All
Reporter: leo...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Database
Product: LibreOffice
Created attachment 100820
--> https://bugs.freedesktop.org/attachment.cgi?id=100820&action=edit
standard filter not working
Problem description:
Unable to filter with standard filter using date and hours.
Create a db linking to a odbc or jdbc existing db (I tried both connecting to
various MS sql server). Tried with italian localization and english too. The
problem is present in Windows and in Ubuntu linux too.
Steps to reproduce:
1. Create a db linking to a odbc or jdbc existing db (I tried both connecting
to various MS sql server)
2. Create a query using at least one column with datetime
3. Use standard filter filtering the datetime field i.e. where greater than of
09/06/2014 09:00:00 . The system will change the string into #09/06/14
09:00:00# but then no filtering will be done. If you omit the hour, just put
date, it works flawlessly.
Operating System: All
Version: 4.2.4.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
