What is date in GIS

CADdog
Honorary member V.I.P. h.c.




    

Posts: 2111
Registered: 04/30/2004

Intel (R) Xeon (R) CPU E5-1620v2 3.7 GHz
16 GB of RAM
NVIDIA Quadro K2000
win7 prof
QGIS 3.0

created on: Jul 11, 2018 14:56   <-- editieren="" zitieren="" --="">   Submit unities:

Hello,
QGIS3.0
I have formatted an attribute column as "Date" in a shp file, e.g. 2018-07-05
I want to filter the layer.
So I thought to myself:
"Date" = '2018-07-05'
Strangely enough, I am offered the value '2018/07/05' with dashes instead of hyphens
both variants tested, instead of = also IS and LIKE and ILIKE tested.
Everything with the error message "Type mismatch or improver type of arguments to ... Operator

Filtering on other columns of numbers or text works as expected

Any ideas?

Complemental description: Both the object selection based on expression and the creation of a rule work with this syntax, only the filter is refused

------------------

Greetings Thomas
CADdog the dog formerly known as TR

AutoCAD speaks with one, but many do not listen.

[This message was edited by CADdog on Jul 11, 2018.]

Write a reply to this post (with Quote/Quote of the contribution)

CADdog
Honorary member V.I.P. h.c.




    

Posts: 2111
Registered on 04/30/2004

Intel (R) Xeon (R) CPU E5-1620v2 3.7 GHz
16 GB of RAM
NVIDIA Quadro K2000
win7 prof
QGIS 3.0

created on: Jul. 12, 2018 7:24 am   <-- editieren="" zitieren="" --="">   Submit unities:
ISpeech
member
Floor cleaners


    

Posts: 56
Registered: 25.01.2018

QGIS 3.4.1, Windows 10 Home; i3-4030U, 1.9 GHz, 4 GB RAM

created on: Jul 12, 2018 1:15 PM   <-- editieren="" zitieren="" --="">   Submit unities:For CADdog only

I tried it in 2.14.15 and it actually doesn't work, with the same error message.

That's really stupid, because I could have used the filtering with the date soon.

Write a reply to this post (with Quote/Quote of the contribution)

Display.:

Advertisement: (Information about the advertising space >>)