Calculate Contact age in a Drupal view












1















I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field.



Anyone know of a module/ combination of modules that will allow me to calculate age in years within the view?






drupal-views







share|improve this question



























    1















    I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field.



    Anyone know of a module/ combination of modules that will allow me to calculate age in years within the view?






    drupal-views







    share|improve this question

























      1












      1








      1








      I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field.



      Anyone know of a module/ combination of modules that will allow me to calculate age in years within the view?






      drupal-views







      share|improve this question














      I'm exposing civi contact data in a drupal view. I can expose date of birth, but not the contact age field.



      Anyone know of a module/ combination of modules that will allow me to calculate age in years within the view?






      drupal-views




      drupal-views






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 11 hours ago









      Craig AlmondCraig Almond

      537313




      537313






















          2 Answers
          2






          active

          oldest

          votes


















          4














          In your view, pull in the CiviCRM birth date field.
          Under date format, select Time ago
          This will present the B.O.B. field as 40 years 7 months



          enter image description here



          To remove years and months from the output you can ‘Rewrite results’ in the view and ‘Trim this field to a maximum length’ and set ‘Maximum length’ to 2 characters






          share|improve this answer
























          • Absolutely Awesome. Thank you Anil

            – Craig Almond
            9 hours ago



















          1














          You need to add views php module



          Add the dob into a view. In this example called birth_date



          Add a global php field.



          Then put this code into the output code box in the global php field



          <?php 
          
$ageTime = $row->birth_date;
          
$t = time();
          
$age = $t-$ageTime;
          
$year = 60 * 60 * 24 * 365;
          
$ageYears = $age / $year;
          
print floor($ageYears);
          
?>





          share|improve this answer
























          • Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

            – Craig Almond
            9 hours ago











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "605"
          };
          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
          },
          noCode: true, onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f28721%2fcalculate-contact-age-in-a-drupal-view%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














          In your view, pull in the CiviCRM birth date field.
          Under date format, select Time ago
          This will present the B.O.B. field as 40 years 7 months



          enter image description here



          To remove years and months from the output you can ‘Rewrite results’ in the view and ‘Trim this field to a maximum length’ and set ‘Maximum length’ to 2 characters






          share|improve this answer
























          • Absolutely Awesome. Thank you Anil

            – Craig Almond
            9 hours ago
















          4














          In your view, pull in the CiviCRM birth date field.
          Under date format, select Time ago
          This will present the B.O.B. field as 40 years 7 months



          enter image description here



          To remove years and months from the output you can ‘Rewrite results’ in the view and ‘Trim this field to a maximum length’ and set ‘Maximum length’ to 2 characters






          share|improve this answer
























          • Absolutely Awesome. Thank you Anil

            – Craig Almond
            9 hours ago














          4












          4








          4







          In your view, pull in the CiviCRM birth date field.
          Under date format, select Time ago
          This will present the B.O.B. field as 40 years 7 months



          enter image description here



          To remove years and months from the output you can ‘Rewrite results’ in the view and ‘Trim this field to a maximum length’ and set ‘Maximum length’ to 2 characters






          share|improve this answer













          In your view, pull in the CiviCRM birth date field.
          Under date format, select Time ago
          This will present the B.O.B. field as 40 years 7 months



          enter image description here



          To remove years and months from the output you can ‘Rewrite results’ in the view and ‘Trim this field to a maximum length’ and set ‘Maximum length’ to 2 characters







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 9 hours ago









          Anil - MillerTechAnil - MillerTech

          98818




          98818













          • Absolutely Awesome. Thank you Anil

            – Craig Almond
            9 hours ago



















          • Absolutely Awesome. Thank you Anil

            – Craig Almond
            9 hours ago

















          Absolutely Awesome. Thank you Anil

          – Craig Almond
          9 hours ago





          Absolutely Awesome. Thank you Anil

          – Craig Almond
          9 hours ago











          1














          You need to add views php module



          Add the dob into a view. In this example called birth_date



          Add a global php field.



          Then put this code into the output code box in the global php field



          <?php 
          
$ageTime = $row->birth_date;
          
$t = time();
          
$age = $t-$ageTime;
          
$year = 60 * 60 * 24 * 365;
          
$ageYears = $age / $year;
          
print floor($ageYears);
          
?>





          share|improve this answer
























          • Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

            – Craig Almond
            9 hours ago
















          1














          You need to add views php module



          Add the dob into a view. In this example called birth_date



          Add a global php field.



          Then put this code into the output code box in the global php field



          <?php 
          
$ageTime = $row->birth_date;
          
$t = time();
          
$age = $t-$ageTime;
          
$year = 60 * 60 * 24 * 365;
          
$ageYears = $age / $year;
          
print floor($ageYears);
          
?>





          share|improve this answer
























          • Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

            – Craig Almond
            9 hours ago














          1












          1








          1







          You need to add views php module



          Add the dob into a view. In this example called birth_date



          Add a global php field.



          Then put this code into the output code box in the global php field



          <?php 
          
$ageTime = $row->birth_date;
          
$t = time();
          
$age = $t-$ageTime;
          
$year = 60 * 60 * 24 * 365;
          
$ageYears = $age / $year;
          
print floor($ageYears);
          
?>





          share|improve this answer













          You need to add views php module



          Add the dob into a view. In this example called birth_date



          Add a global php field.



          Then put this code into the output code box in the global php field



          <?php 
          
$ageTime = $row->birth_date;
          
$t = time();
          
$age = $t-$ageTime;
          
$year = 60 * 60 * 24 * 365;
          
$ageYears = $age / $year;
          
print floor($ageYears);
          
?>






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 9 hours ago









          Tony HorrocksTony Horrocks

          71738




          71738













          • Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

            – Craig Almond
            9 hours ago



















          • Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

            – Craig Almond
            9 hours ago

















          Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

          – Craig Almond
          9 hours ago





          Thanks Tony. Anil's suggestion has worked a charm. So I haven't needed to dabble with PHP

          – Craig Almond
          9 hours ago


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to CiviCRM 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%2fcivicrm.stackexchange.com%2fquestions%2f28721%2fcalculate-contact-age-in-a-drupal-view%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

          Paul Cézanne

          Image
          Pour l’article ayant un titre homophone, voir Sézanne. Paul Cézanne.mw-parser-output .entete.artiste{background-image:url("//upload.wikimedia.org/wikipedia/commons/f/f3/Picto_infobox_artiste.png")} Autoportrait vers 1861 Naissance 19 janvier 1839 Aix-en-Provence (France) Décès 22 octobre 1906 (à 67 ans) Aix-en-Provence (France) Nationalité Française Activité Peintre Formation Académie de Charles Suisse Maître Joseph Gilbert, Antoine Guillemet, Camille Pissarro Mouvement Impressionnisme postimpressionnisme Influencé par Eugène Delacroix, Gustave Courbet, Véronèse A influencé Braque, Picasso, Matisse Conjoint Hortense Fiquet (depuis 1886) Enfant Paul Cézanne  ( d ) Œuvres principales La Montagne Sainte-Victoire, Portrait de madame Cézanne signature modifier - modifier le code - modifier Wikidata Paul Cézanne , né le 19 janvier 1839 à Aix-en-Provence et mort le 22 octobre 1906 dans la mê...
          Read more

          UIScrollView CustomStickyHeader Resize height generates problems when scroll is too fast

          Image
          0 I have been trying for a while to create a UIViewController that has a CustomStickyHeader and a UITableView. The idea I have been following is use the UITableView scrolling for changing the header view with the value of the contentOffset. The layout for the ViewController (AlbumsViewController) looks like: The UItableView Scrolling functions from the delegate are implemented like that: func scrollViewDidScroll(_ scrollView: UIScrollView) { let endReached = contentTableView.contentOffset.y >= (contentTableView.contentSize.height - contentTableView.frame.size.height) let isUP = lastContentOffset > scrollView.contentOffset.y if scrollView.contentOffset.y < 0 { headerHeightConstraint.constant += abs(scrollView.contentOffset.y) } else{ if !endReached{ ...
          Read more

          Angular material date-picker (MatDatepicker) auto completes the date on focus out

          Image
          3 3 I am using angular material/mat-datepicker in my project and whenever the user enters one digit inside of it, and goes out of focus - the date picker is auto completing with a random date. Example Just enter 1 and go out of focus, or enter 5/5/20 The date picker is adding date automatically Update : Also I am using reactive forms and I'm validating the input with that approach Can I disable this ? angular datepicker angular-material angular6 angular-material-datetimepicker share | improve this question edited Nov 20 '18 at 13:21 ...
          Read more