What expression will give age in years in QGIS?
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?
qgis-plugins
edited Mar 29 at 18:16
Vince
14.8k32849
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
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?
qgis-plugins
edited Mar 29 at 18:16
Vince
14.8k32849
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
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?
qgis-plugins
edited Mar 29 at 18:16
Vince
14.8k32849
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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?
qgis-plugins
qgis-plugins
edited Mar 29 at 18:16
Vince
14.8k32849
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 29 at 18:16
Vince
14.8k32849
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 29 at 18:16
Vince
14.8k32849
edited Mar 29 at 18:16
Vince
14.8k32849
edited Mar 29 at 18:16
Vince
14.8k32849
14.8k32849
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
asked Mar 29 at 17:07
TraineeGISTraineeGIS
113
113
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
TraineeGIS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Or use the age function
year(age(now() ,"yourdatefield"))
answered Mar 29 at 18:21
cskcsk
9,5751035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
add a comment |
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 at 18:19
Gabriel C.Gabriel C.
1,342320
add a comment |
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
TraineeGIS is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317171%2fwhat-expression-will-give-age-in-years-in-qgis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Or use the age function
year(age(now() ,"yourdatefield"))
answered Mar 29 at 18:21
cskcsk
9,5751035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
add a comment |
Or use the age function
year(age(now() ,"yourdatefield"))
answered Mar 29 at 18:21
cskcsk
9,5751035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
add a comment |
Or use the age function
year(age(now() ,"yourdatefield"))
answered Mar 29 at 18:21
cskcsk
9,5751035
Or use the age function
year(age(now() ,"yourdatefield"))
answered Mar 29 at 18:21
cskcsk
9,5751035
answered Mar 29 at 18:21
cskcsk
9,5751035
answered Mar 29 at 18:21
cskcsk
9,5751035
answered Mar 29 at 18:21
cskcsk
9,5751035
9,5751035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
add a comment |
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
Mar 29 at 18:25
add a comment |
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 at 18:19
Gabriel C.Gabriel C.
1,342320
add a comment |
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 at 18:19
Gabriel C.Gabriel C.
1,342320
add a comment |
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 at 18:19
Gabriel C.Gabriel C.
1,342320
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 at 18:19
Gabriel C.Gabriel C.
1,342320
answered Mar 29 at 18:19
Gabriel C.Gabriel C.
1,342320
answered Mar 29 at 18:19
Gabriel C.Gabriel C.
1,342320
answered Mar 29 at 18:19
Gabriel C.Gabriel C.
1,342320
1,342320
add a comment |
add a comment |
TraineeGIS is a new contributor. Be nice, and check out our Code of Conduct.
TraineeGIS is a new contributor. Be nice, and check out our Code of Conduct.
TraineeGIS is a new contributor. Be nice, and check out our Code of Conduct.
TraineeGIS is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317171%2fwhat-expression-will-give-age-in-years-in-qgis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
