What expression will give age in years in QGIS? The Next CEO of Stack OverflowQGIS Points to Path Plugin Date/time errorHow can I get the field index of the new layer in my script using Python?plugin manager fault installationSeparate a string value in two integers in QGISHow to call default tool in QGIS inside plugin using python script?clustering categorized datawriting an expression in qgis (2.14.0)What has replaced QGIS SPIT (Shapefile to PostGIS Import Tool)?QGIS plugin fields will not resetSending data between QGIS and other programs in real time
Is there an analogue of projective spaces for proper schemes?
How to make a variable always equal to the result of some calculations?
How do scammers retract money, while you can’t?
If the heap is initialized for security, then why is the stack uninitialized?
Is micro rebar a better way to reinforce concrete than rebar?
Can we say or write : "No, it'sn't"?
WOW air has ceased operation, can I get my tickets refunded?
Elegant way to replace substring in a regex with optional groups in Python?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
Won the lottery - how do I keep the money?
Interfacing a button to MCU (and PC) with 50m long cable
Is there a way to save my career from absolute disaster?
Contours of a clandestine nature
Solving Integral Equation by Converting to Differential Equations
Different harmonic changes implied by a simple descending scale
Why do remote companies require working in the US?
Why do professional authors make "consistency" mistakes? And how to avoid them?
Would a galaxy be visible from outside, but nearby?
Can you replace a racial trait cantrip when leveling up?
Anatomically Correct Strange Women In Ponds Distributing Swords
How fast would a person need to move to trick the eye?
Workaholic Formal/Informal
Why does standard notation not preserve intervals (visually)
Sending manuscript to multiple publishers
What expression will give age in years in QGIS?
The Next CEO of Stack OverflowQGIS Points to Path Plugin Date/time errorHow can I get the field index of the new layer in my script using Python?plugin manager fault installationSeparate a string value in two integers in QGISHow to call default tool in QGIS inside plugin using python script?clustering categorized datawriting an expression in qgis (2.14.0)What has replaced QGIS SPIT (Shapefile to PostGIS Import Tool)?QGIS plugin fields will not resetSending data between QGIS and other programs in real time
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 5 hours ago
Vince
14.8k32849
asked 6 hours ago
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 5 hours ago
Vince
14.8k32849
asked 6 hours ago
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 5 hours ago
Vince
14.8k32849
asked 6 hours ago
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 5 hours ago
Vince
14.8k32849
asked 6 hours ago
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 5 hours ago
Vince
14.8k32849
asked 6 hours ago
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 5 hours ago
Vince
14.8k32849
edited 5 hours ago
Vince
14.8k32849
edited 5 hours ago
Vince
14.8k32849
14.8k32849
asked 6 hours ago
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 6 hours ago
TraineeGISTraineeGIS
113
asked 6 hours ago
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 5 hours ago
cskcsk
9,4601035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
5 hours ago
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 5 hours ago
Gabriel C.Gabriel C.
1,344320
add a comment |
Your Answer
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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 5 hours ago
cskcsk
9,4601035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
5 hours ago
add a comment |
Or use the age function
year(age(now() ,"yourdatefield"))
answered 5 hours ago
cskcsk
9,4601035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
5 hours ago
add a comment |
Or use the age function
year(age(now() ,"yourdatefield"))
answered 5 hours ago
cskcsk
9,4601035
Or use the age function
year(age(now() ,"yourdatefield"))
answered 5 hours ago
cskcsk
9,4601035
answered 5 hours ago
cskcsk
9,4601035
answered 5 hours ago
cskcsk
9,4601035
answered 5 hours ago
cskcsk
9,4601035
9,4601035
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
5 hours ago
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.
5 hours ago
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
5 hours ago
Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P
– Gabriel C.
5 hours ago
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 5 hours ago
Gabriel C.Gabriel C.
1,344320
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 5 hours ago
Gabriel C.Gabriel C.
1,344320
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 5 hours ago
Gabriel C.Gabriel C.
1,344320
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 5 hours ago
Gabriel C.Gabriel C.
1,344320
answered 5 hours ago
Gabriel C.Gabriel C.
1,344320
answered 5 hours ago
Gabriel C.Gabriel C.
1,344320
answered 5 hours ago
Gabriel C.Gabriel C.
1,344320
1,344320
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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
