qgis convert string to date

Asked Sep 06 '17 at 14:26

Active Sep 06 '17 at 14:26

Viewed 873 times

I'm having the same problem from this previous question.

I keep getting some nulls after running expression. Not sure why it works on some dates

I have dates(strings) in the form 1/4/2005, 11/11/2004, etc

Here is code I used in field calculator:

btw data will be uploaded to django app using PostGeSQL

from qgis.core import *
from qgis.gui import *
from PyQt4.QtCore import QDate

@qgsfunction(args="auto", group='Python')
def parse_date_dmy(fromval, feature, parent):
    return QDate.fromString(fromval, 'dd/MM/yyyy')

asked Sep 06 '17 at 14:26

geomajor56

2,102
2
18
26

fast guess is, that there is a difference between 1/4/2005 and 01/04/2005 – LaughU Sep 06 '17 at 14:33
can you say which datas work and which don't? – Ian Turton Sep 06 '17 at 14:33
the text i'm trying to convert is month/day/year like 1/29/2014. could i have the wrong format? I'm using dd/MM/yyyy in expression – geomajor56 Sep 06 '17 at 14:41
1

just noticed some years are yy only, not yyyy – geomajor56 Sep 06 '17 at 14:41

qgis convert string to date

0 Answers0