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

How to transpose the 1st and -1th levels of arbitrarily nested array?

How did people program for Consoles with multiple CPUs?

Why has the US not been more assertive in confronting Russia in recent years?

Why am I allowed to create multiple unique pointers from a single object?

If the heap is initialized for security, then why is the stack uninitialized?

What does "Its cash flow is deeply negative" mean?

multiple labels for a single equation

Why do we use the plural of movies in this phrase "We went to the movies last night."?

How did the Bene Gesserit know how to make a Kwisatz Haderach?

Contours of a clandestine nature

Is it ever safe to open a suspicious html file (e.g. email attachment)?

What flight has the highest ratio of time difference to flight time?

Received an invoice from my ex-employer billing me for training; how to handle?

SQL Server 2016 - excessive memory grant warning on poor performing query

Non-deterministic sum of floats

What is ( CFMCC ) on ILS approach chart?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

Is there an analogue of projective spaces for proper schemes?

Elegant way to replace substring in a regex with optional groups in Python?

What benefits would be gained by using human laborers instead of drones in deep sea mining?

Is it professional to write unrelated content in an almost-empty email?

Which tube will fit a -(700 x 25c) wheel?

Limits on contract work without pre-agreed price/contract (UK)

Novel about a guy who is possessed by the divine essence and the world ends?



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










1















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?










share|improve this question









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.
























    1















    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?










    share|improve this question









    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.






















      1












      1








      1








      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?










      share|improve this question









      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






      share|improve this question









      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.











      share|improve this question









      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.









      share|improve this question




      share|improve this question








      edited 5 hours ago









      Vince

      14.8k32849




      14.8k32849






      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 7 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.




















          2 Answers
          2






          active

          oldest

          votes


















          4














          Or use the age function



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





          share|improve this answer























          • 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


















          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.






          share|improve this answer























            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.









            draft saved

            draft discarded


















            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









            4














            Or use the age function



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





            share|improve this answer























            • 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















            4














            Or use the age function



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





            share|improve this answer























            • 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













            4












            4








            4







            Or use the age function



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





            share|improve this answer













            Or use the age function



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






            share|improve this answer












            share|improve this answer



            share|improve this answer










            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

















            • 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













            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.






            share|improve this answer



























              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.






              share|improve this answer

























                2












                2








                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.






                share|improve this answer













                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.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 5 hours ago









                Gabriel C.Gabriel C.

                1,342320




                1,342320




















                    TraineeGIS is a new contributor. Be nice, and check out our Code of Conduct.









                    draft saved

                    draft discarded


















                    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.




                    draft saved


                    draft discarded














                    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





















































                    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







                    Popular posts from this blog

                    Magento 2 duplicate PHPSESSID cookie when using session_start() in custom php scriptMagento 2: User cant logged in into to account page, no error showing!Magento duplicate on subdomainGrabbing storeview from cookie (after using language selector)How do I run php custom script on magento2Magento 2: Include PHP script in headerSession lock after using Cm_RedisSessionscript php to update stockMagento set cookie popupMagento 2 session id cookie - where to find it?How to import Configurable product from csv with custom attributes using php scriptMagento 2 run custom PHP script

                    Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

                    How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2