Skip to main content
Geographic Information Systems

Return to Question

added 4 characters in body; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

Select Selecting latest date with QGIS field calculator?

My shapefile contains columns like "Street", "number" and "date". 

What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. 

Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

Select latest date with field calculator

My shapefile contains columns like "Street", "number" and "date". What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

Selecting latest date with QGIS field calculator?

My shapefile contains columns like "Street", "number" and "date". 

What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. 

Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

naming
Source Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

my shp fileMy shapefile contains columns like "Street", "number" and "date". What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

Regards.

my shp file contains columns like "Street", "number" and "date". What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

Regards.

My shapefile contains columns like "Street", "number" and "date". What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

Source Link
Pimpel
Pimpel
  • 2.4k
  • 3
  • 25
  • 40

Select latest date with field calculator

my shp file contains columns like "Street", "number" and "date". What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number"), we want to get rid of the older one (this feature should be deleted). I also added a column "duplicates" which shows 1 when we have more then one date for a house number. Has anyone an idea how to select the latest dates (or how to delete the oldest ones) with the field calculator?

Regards.