I am getting the message below from TimeManager in QGIS. The error message is confusing because the date is displays would seem to be a valid format (I'm using YYYY-MM-DD). The table is in sqllite format.

Any suggestions where to look for the problem? I have done a quick check of this large table, but I don't see any problems with the date field.

TimeManager error dialog

Here is snippet of the table:

Table showing date format

Here is a snippet of the Field types in the table. The date field is a QString.

enter image description here

  • 1
    what is your data source and what does your input time data look like? – DPSSpatial Apr 5 '16 at 18:36
  • The data source is an sqllite table and the date field looks like 2001-12-03. – craigmcg Apr 5 '16 at 18:40
  • adding that to your question, and screen captures of your date data would help... – DPSSpatial Apr 5 '16 at 18:43

There is a known issue with datetime columns: https://github.com/anitagraser/TimeManager/issues/159

As a workaround, you could cast to text. Text fields from SpatiaLite work fine for me.

|improve this answer|||||
  • I added a snippet showing the field as type QString. So isn't it already text? – craigmcg Apr 5 '16 at 19:15
  • Can you share the data? I cannot reproduce your issue with strings. – underdark Apr 5 '16 at 19:40
  • Yes, I uploaded a small subset of my dataset that demonstrates the problem to the github page. – craigmcg Apr 6 '16 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.