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

Yu-Gi-Oh cards in Python 3

How to count occurrences of text in a file?

How to avoid supervisors with prejudiced views?

Does destroying a Lich's phylactery destroy the soul within it?

How to use ReplaceAll on an expression that contains a rule

Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?

Help! I cannot understand this game’s notations!

Ubuntu - "sudo iptables" command works in terminal, doesn't work in bash script

What steps are necessary to read a Modern SSD in Medieval Europe?

Aggressive Under-Indexing and no data for missing index

Inexact numbers as keys in Association?

From jafe to El-Guest

Are the names of these months realistic?

Is there a reasonable and studied concept of reduction between regular languages?

Define command that accepts \ in arguments

What day is it again?

Strength of face-nailed connection for stair steps

Regression vs Random Forest - Combination of features

Does Germany produce more waste than the US?

Is there such a thing as never melting snow?

Is it convenient to ask the journal's editor for two additional days to complete a review?

Would a completely good Muggle be able to use a wand?

Does regularization penalize models that are simpler than needed?

Sulfuric acid symmetry point group



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 2 days 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 2 days 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.
            2 days 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.
              2 days 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.
              2 days 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 2 days ago









            cskcsk

            9,4751035




            9,4751035












            • Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P

              – Gabriel C.
              2 days ago

















            • Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P

              – Gabriel C.
              2 days ago
















            Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P

            – Gabriel C.
            2 days ago





            Sometimes I get comfortable using some function and just forget that there might be another one that saves some time... :P

            – Gabriel C.
            2 days 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 2 days 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

                    Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221

                    Creating closest line along the point''s azimuth using PostgreSQL Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

                    Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given