{"id":13612,"date":"2018-12-07T11:25:31","date_gmt":"2018-12-07T05:55:31","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=13612"},"modified":"2020-06-01T12:59:37","modified_gmt":"2020-06-01T12:59:37","slug":"calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/","title":{"rendered":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow"},"content":{"rendered":"<h2><strong>Introduction:<\/strong><\/h2>\n<p>If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow.<\/p>\n<p>Below example is configured for contact entity and flow will trigger whenever the record is created in Contact Entity.<\/p>\n<p>Go to Office 365\u00a0\u2192 Microsoft Flow<\/p>\n<ul>\n<li>Click on \u2018Create from Blank\u2019 button, to create new Flow.<\/li>\n<li>You will be redirected to below screen then click on \u2018When a record is created\u2019 option which is highlighted in below screenshot, to trigger Flow on create of Contact entity record.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-14437\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png\" alt=\"\" width=\"806\" height=\"389\" \/><\/p>\n<ul>\n<li>After this you will be redirected to below screen, Please select Organization Name (Your CRM Organization) and Entity name (In this case we considered <strong>Contact<\/strong> entity)<img decoding=\"async\" class=\"aligncenter wp-image-14438\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow1.png\" alt=\"\" width=\"777\" height=\"164\" \/><\/li>\n<li>After this, you need to add condition to check if <strong>Birthdate<\/strong> field is Empty or not to proceed.Below is fetch expression to validate the same.@empty(triggerBody()?[&#8216;birthdate&#8217;])<img decoding=\"async\" class=\"aligncenter wp-image-14439\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow2.png\" alt=\"\" width=\"674\" height=\"189\" \/><\/li>\n<li>We need to add an Action to update the record and calculate Age field value in a number of* years using from expression.To update record use highlighted action as shown in below screenshot:<img decoding=\"async\" class=\"aligncenter size-full wp-image-14440\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow3.png\" alt=\"\" width=\"507\" height=\"468\" \/><\/li>\n<\/ul>\n<p>After this you need to select Organization Name and Entity Name once again. Here we need to select one more field i.e. <strong>Record Identifier<\/strong> to uniquely identify the record which needs to be updated.<\/p>\n<p>Follow below screenshot to set the <strong>Record Identifier<\/strong>, here we select <strong>Contact<\/strong>:<img decoding=\"async\" class=\"aligncenter wp-image-14441\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow4.png\" alt=\"\" width=\"812\" height=\"214\" \/><\/p>\n<p>Click on \u2018<strong>Show Advanced option<\/strong>\u2019 as shown in below screenshot, to populate value of Age field:<\/p>\n<p style=\"padding-left: 120px;\"><img decoding=\"async\" class=\"aligncenter wp-image-14442\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow5.png\" alt=\"\" width=\"524\" height=\"252\" \/><\/p>\n<p>Find Age field in list then click on \u201c<strong>Add dynamic content<\/strong>\u201d then add mentioned expression as below under \u201c<strong>Expression\u201d<\/strong> tab then click <strong>OK<\/strong>.<\/p>\n<p><strong>int(split(string(div(div(sub(ticks(utcNow())<\/strong>,<strong>ticks(triggerBody()<\/strong>?[&#8216;birthdate&#8217;]<strong>))<\/strong>,864000000000<strong>)<\/strong>,365.25<strong>))<\/strong>,&#8217;.&#8217;<strong>)<\/strong>[0]<strong>)<\/strong><\/p>\n<p><strong><img decoding=\"async\" class=\"aligncenter size-full wp-image-14436\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow6.png\" alt=\"\" width=\"603\" height=\"138\" \/><\/strong><\/p>\n<p><strong>Conclusion:<\/strong><\/p>\n<p>Using the simple steps given above user can calculate the Age in Dynamics 365 CRM as a number of years using Microsoft Flow.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/product\/integrations\/inolink-quickbooks-microsoft-dynamics-crm\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-13621\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/Banner-InoLink-QuickBooks-Integration-with-Microsoft-Dynamics-365-Dynamics-CRM-1.jpg\" alt=\"InoLink-QuickBooks-Integration-with-Microsoft-Dynamics-365-Dynamics-CRM\" width=\"825\" height=\"102\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/\">Read More: Calculate Age in Dynamics 365 as Number of Years using\u2026 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":13620,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,18,19,36,1985],"tags":[1150,1153],"class_list":["post-13612","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-microsoft-flow","category-power-automate","tag-microsoft-flow","tag-microsoft-flow-dynamics-365"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Inogic\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta property=\"og:description\" content=\"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-12-07T05:55:31+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-06-01T12:59:37+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inogicindia\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Inogic\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#blogposting\",\"name\":\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks\",\"headline\":\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow\",\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/Calculate-Age-in-No-Of-Years-using-MS-Flow-1-1.png\",\"width\":150,\"height\":150,\"caption\":\"Calculate Age in No Of Years using MS Flow\"},\"datePublished\":\"2018-12-07T11:25:31+05:30\",\"dateModified\":\"2020-06-01T12:59:37+05:30\",\"inLanguage\":\"en-US\",\"commentCount\":4,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#webpage\"},\"articleSection\":\"Dynamics 365, Dynamics 365 v9, Dynamics CRM, Microsoft Flow, Power Automate, Microsoft Flow, Microsoft Flow Dynamics 365\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/#listItem\",\"name\":\"Dynamics 365\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/#listItem\",\"position\":2,\"name\":\"Dynamics 365\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#listItem\",\"name\":\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#listItem\",\"position\":3,\"name\":\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-365\\\/#listItem\",\"name\":\"Dynamics 365\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"By Inogic\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inogic-logo.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#organizationLogo\",\"width\":1000,\"height\":325,\"caption\":\"inogic logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inogicindia\",\"https:\\\/\\\/twitter.com\\\/inogic\",\"https:\\\/\\\/www.instagram.com\\\/inogicindia\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCM4V7ousgLSu1hbOEv4DUuQ\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/inogicindia\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/\",\"name\":\"Inogic\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Inogic\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#webpage\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/\",\"name\":\"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/Calculate-Age-in-No-Of-Years-using-MS-Flow-1-1.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#mainImage\",\"width\":150,\"height\":150,\"caption\":\"Calculate Age in No Of Years using MS Flow\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2018\\\/12\\\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\\\/#mainImage\"},\"datePublished\":\"2018-12-07T11:25:31+05:30\",\"dateModified\":\"2020-06-01T12:59:37+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"alternateName\":\"Inogic\",\"description\":\"By Inogic\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks","description":"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created","canonical_url":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#blogposting","name":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks","headline":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow","author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/Calculate-Age-in-No-Of-Years-using-MS-Flow-1-1.png","width":150,"height":150,"caption":"Calculate Age in No Of Years using MS Flow"},"datePublished":"2018-12-07T11:25:31+05:30","dateModified":"2020-06-01T12:59:37+05:30","inLanguage":"en-US","commentCount":4,"mainEntityOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#webpage"},"isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#webpage"},"articleSection":"Dynamics 365, Dynamics 365 v9, Dynamics CRM, Microsoft Flow, Power Automate, Microsoft Flow, Microsoft Flow Dynamics 365"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.inogic.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/#listItem","name":"Dynamics 365"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/#listItem","position":2,"name":"Dynamics 365","item":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#listItem","name":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#listItem","position":3,"name":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow","previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/#listItem","name":"Dynamics 365"}}]},{"@type":"Organization","@id":"https:\/\/www.inogic.com\/blog\/#organization","name":"Microsoft Dynamics 365 CRM Tips and Tricks","description":"By Inogic","url":"https:\/\/www.inogic.com\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/02\/inogic-logo.png","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#organizationLogo","width":1000,"height":325,"caption":"inogic logo"},"image":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/inogicindia","https:\/\/twitter.com\/inogic","https:\/\/www.instagram.com\/inogicindia\/","https:\/\/www.youtube.com\/channel\/UCM4V7ousgLSu1hbOEv4DUuQ","https:\/\/www.linkedin.com\/company\/inogicindia"]},{"@type":"Person","@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author","url":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/","name":"Inogic","image":{"@type":"ImageObject","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g","width":96,"height":96,"caption":"Inogic"}},{"@type":"WebPage","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#webpage","url":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/","name":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks","description":"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#breadcrumblist"},"author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"creator":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/Calculate-Age-in-No-Of-Years-using-MS-Flow-1-1.png","@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#mainImage","width":150,"height":150,"caption":"Calculate Age in No Of Years using MS Flow"},"primaryImageOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/#mainImage"},"datePublished":"2018-12-07T11:25:31+05:30","dateModified":"2020-06-01T12:59:37+05:30"},{"@type":"WebSite","@id":"https:\/\/www.inogic.com\/blog\/#website","url":"https:\/\/www.inogic.com\/blog\/","name":"Microsoft Dynamics 365 CRM Tips and Tricks","alternateName":"Inogic","description":"By Inogic","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic","og:type":"article","og:title":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks","og:description":"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created","og:url":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/","og:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png","og:image:secure_url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png","article:published_time":"2018-12-07T05:55:31+00:00","article:modified_time":"2020-06-01T12:59:37+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow - Microsoft Dynamics 365 CRM Tips and Tricks","twitter:description":"Introduction: If we want to calculate the Age in a number of years using Birthdate field (i.e. Date type field) in CRM we can achieve this in multiple ways. Here we tried to achieve this functionality using MS Flow. Below example is configured for contact entity and flow will trigger whenever the record is created","twitter:creator":"@inogic","twitter:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/12\/flow.png","twitter:label1":"Written by","twitter:data1":"Inogic","twitter:label2":"Est. reading time","twitter:data2":"2 minutes"},"aioseo_meta_data":{"post_id":"13612","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-02-02 07:01:59","updated":"2025-07-04 05:17:49","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/\" title=\"Dynamics 365\">Dynamics 365<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tCalculate Age in Dynamics 365 as Number of Years using Microsoft Flow\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.inogic.com\/blog"},{"label":"Dynamics 365","link":"https:\/\/www.inogic.com\/blog\/category\/dynamics-365\/"},{"label":"Calculate Age in Dynamics 365 as Number of Years using Microsoft Flow","link":"https:\/\/www.inogic.com\/blog\/2018\/12\/calculate-age-in-dynamics-365-as-number-of-years-using-microsoft-flow\/"}],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=13612"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13612\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/13620"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=13612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=13612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=13612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}