What expression will give age in years in QGIS?

Question

I have the date at which a pipe was laid. I want to create a field giving the age of the pipe in years. How do I do this in QGIS?

Can you please give an example of age and corresponding year ? — J. Monticolo, Apr 08 '19 at 07:19

score 5 · Answer 1 · answered Mar 29 '19 at 18:21

5

Or use the age function

year(age(now() ,"yourdatefield"))

answered Mar 29 '19 at 18:21

csk

Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P – Gabriel Mar 29 '19 at 18:25

score 2 · Answer 2 · answered Mar 29 '19 at 18:19

2

From the field calculator, this expression could do the trick:

year(now()) - year('the laying date')

Check if the date format will work, but aside from that, it should be pretty easy. The laying date can be replaced by a field value.

answered Mar 29 '19 at 18:19

Gabriel

2 Answers2