Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I have a shapefile with polygons. Each polygon contains a date (fully written in text, for example: '2 june 2018') in the attribute table. This field is format 'text'. Now, I would like to convert these fields / this column to a new column with the dates written in numbers (for example '02/06/2018'). The new fields have to be formatted as 'date'.
Does anybody know how to do this quickly in the field calculator using a formula?
First I'd like to note that only the international date format is of type "date": yyyy-mm-dd. All other types are just representations of this date and depend e.g. on your settings about locales in QGIS. You can change these in Settings --> Options --> General. That being said, you can use this expression:
to_date('2 june 2018', 'd MMMM yyyy', 'en')
respectively replace the date with your field.
