Bug 79886 - EDITING: standard filter problem in date with hours
Summary: EDITING: standard filter problem in date with hours
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 4.2.4.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-06-10 13:51 UTC by leocor
Modified: 2015-01-03 17:39 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
standard filter not working (419.07 KB, image/png)
2014-06-10 13:51 UTC, leocor
Details

Description leocor 2014-06-10 13:51:15 UTC
Created attachment 100820 [details]
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
Comment 1 Julien Nabet 2014-10-11 14:22:18 UTC
On pc Debian x86-64 with LO Debian package 4.3.2 + jdbc on Mysql Base, I don't reproduce this.
(Indeed, when coming back to filter, "#" are added)

Could you give a try with last stable LO version 4.3.2?
Comment 2 Alex Thurgood 2015-01-03 17:39:41 UTC
Adding self to CC if not already on


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.