{"id":35932,"date":"2023-09-07T16:07:09","date_gmt":"2023-09-07T10:37:09","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=35932"},"modified":"2025-07-21T12:33:14","modified_gmt":"2025-07-21T07:03:14","slug":"how-to-use-the-datedifference-function-in-power-automate","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/","title":{"rendered":"How to use the dateDifference() function in Power Automate"},"content":{"rendered":"<p>Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of <strong>dateDifference()<\/strong> function, Microsoft has eased that out.<\/p>\n<p>In this blog, we will see how the process of calculating the difference between two dates has been simplified compared to the complex logic of using <strong>ticks()<\/strong> function.<\/p>\n<p><strong>Scenario:<\/strong><\/p>\n<p>Let\u2019s see the scenario of calculating the days remaining for a subscription to expire from today\u2019s date. In many organizations, it&#8217;s very important to remain aware of when various licenses are about to expire. The ability to accurately determine the remaining days until a license subscription concludes holds high importance.<\/p>\n<p>Traditionally, this task could be achieved using the <strong>ticks()<\/strong> function, which seemed complex compared to the <strong>dateDifference()<\/strong> function. By leveraging the <strong>dateDifference()<\/strong> function, individuals can effortlessly compute the exact number of days left until a license subscription reaches its termination date. I have created a power automate flow for the creation of <strong>Account<\/strong> entity records. Also, I have fields for <strong>Start Date<\/strong> and <strong>End Date<\/strong> of a License, and also a whole number field for <strong>Expiry days<\/strong> field to display the remaining days until the license expires.<\/p>\n<p>Below are the steps for the power automate flow.<\/p>\n<ul>\n<li>Creation of Account.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-35938\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg\" alt=\"Power Automate\" width=\"719\" height=\"255\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg 719w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate-300x106.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate-660x234.jpeg 660w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/p>\n<ul>\n<li>Add an action \u201cUpdate a row\u201d to show the remaining expiration days.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-35937\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/2Power-Automate.jpeg\" alt=\"Power Automate\" width=\"728\" height=\"157\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/2Power-Automate.jpeg 728w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/2Power-Automate-300x65.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/2Power-Automate-660x142.jpeg 660w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/p>\n<ul>\n<li>Adding the datedifference() function in the Expiry days field.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-35936\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/3Power-Automate.jpeg\" alt=\"Power Automate\" width=\"948\" height=\"473\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/3Power-Automate.jpeg 948w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/3Power-Automate-300x150.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/3Power-Automate-768x383.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/3Power-Automate-660x329.jpeg 660w\" sizes=\"(max-width: 948px) 100vw, 948px\" \/><\/p>\n<p><strong>Expression \u2013 <\/strong><\/p>\n<p>dateDifference(formatDateTime(utcNow(),\u2019yyyy-MM-dd\u2019), formatDateTime(triggerOutputs()?[\u2018body\/cr9a6_enddate\u2019],\u2019yyyy-MM-dd\u2019))<\/p>\n<p>Here is the output of the remaining days for the expiration of the license as per the current date, i.e., 25<sup>th<\/sup> August, 2023.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-35935\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/4Power-Automate.jpeg\" alt=\"Power Automate\" width=\"750\" height=\"452\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/4Power-Automate.jpeg 750w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/4Power-Automate-300x181.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/4Power-Automate-660x398.jpeg 660w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<p>The output is in <strong>{days}.{hours}:{minutes}:{seconds}<\/strong> format.<\/p>\n<p>Now if we want to show the difference only in days, we can use the <strong>split()<\/strong> function to get only days, as can be seen below.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-35934\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/5Power-Automate.jpeg\" alt=\"Power Automate\" width=\"930\" height=\"480\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/5Power-Automate.jpeg 930w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/5Power-Automate-300x155.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/5Power-Automate-768x396.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/5Power-Automate-660x341.jpeg 660w\" sizes=\"(max-width: 930px) 100vw, 930px\" \/><\/p>\n<p><strong>Expression:<\/strong> split(dateDifference(formatDateTime(utcNow(),&#8217;yyyy-MM-dd&#8217;),formatDateTime(triggerOutputs()?[&#8216;body\/cr9a6_enddate&#8217;],&#8217;yyyy-MM-dd&#8217;)),&#8217;.&#8217;)[0]\n<p>Here we get the only days remaining for the expiration of the license by extracting the hours, mins, secs.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-35933\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/6Power-Automate.jpeg\" alt=\"Power Automate\" width=\"716\" height=\"492\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/6Power-Automate.jpeg 716w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/6Power-Automate-300x206.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/6Power-Automate-660x454.jpeg 660w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>In this blog, we explored the <strong>dateDifference()<\/strong> function and saw how it simplifies the complex logic for calculating the difference between the two dates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/\">Read More: How to use the dateDifference() function in Power Automate &raquo;<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1985],"tags":[1975,3189],"class_list":["post-35932","post","type-post","status-publish","format-standard","hentry","category-power-automate","tag-power-automate","tag-power-automate-datedifference"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference\" \/>\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\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/\" \/>\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=\"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta property=\"og:description\" content=\"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"719\" \/>\n\t\t<meta property=\"og:image:height\" content=\"255\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-09-07T10:37:09+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-07-21T07:03:14+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=\"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference\" \/>\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\/2023\/09\/1Power-Automate.jpeg\" \/>\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\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#blogposting\",\"name\":\"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks\",\"headline\":\"How to use the dateDifference() function in Power Automate\",\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/sarika\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/1Power-Automate.jpeg\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#articleImage\",\"width\":719,\"height\":255,\"caption\":\"Power Automate\"},\"datePublished\":\"2023-09-07T16:07:09+05:30\",\"dateModified\":\"2025-07-21T12:33:14+05:30\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#webpage\"},\"articleSection\":\"Power Automate, Power Automate, power automate datedifference\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#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\\\/power-automate\\\/#listItem\",\"name\":\"Power Automate\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-automate\\\/#listItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-automate\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#listItem\",\"name\":\"How to use the dateDifference() function in Power Automate\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#listItem\",\"position\":3,\"name\":\"How to use the dateDifference() function in Power Automate\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-automate\\\/#listItem\",\"name\":\"Power Automate\"}}]},{\"@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\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#organizationLogo\",\"width\":1000,\"height\":325,\"caption\":\"inogic logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#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\\\/sarika\\\/#author\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/sarika\\\/\",\"name\":\"Inogic\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7e3157d3c9d28231b0a67ff18cc6445c87e889473ae03080f7026c5482ce860?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Inogic\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#webpage\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/\",\"name\":\"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2023\\\/09\\\/how-to-use-the-datedifference-function-in-power-automate\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/sarika\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/sarika\\\/#author\"},\"datePublished\":\"2023-09-07T16:07:09+05:30\",\"dateModified\":\"2025-07-21T12:33:14+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":"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks","description":"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference","canonical_url":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#blogposting","name":"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks","headline":"How to use the dateDifference() function in Power Automate","author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/sarika\/#author"},"publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#articleImage","width":719,"height":255,"caption":"Power Automate"},"datePublished":"2023-09-07T16:07:09+05:30","dateModified":"2025-07-21T12:33:14+05:30","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#webpage"},"isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#webpage"},"articleSection":"Power Automate, Power Automate, power automate datedifference"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#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\/power-automate\/#listItem","name":"Power Automate"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-automate\/#listItem","position":2,"name":"Power Automate","item":"https:\/\/www.inogic.com\/blog\/category\/power-automate\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#listItem","name":"How to use the dateDifference() function in Power Automate"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#listItem","position":3,"name":"How to use the dateDifference() function in Power Automate","previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-automate\/#listItem","name":"Power Automate"}}]},{"@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\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#organizationLogo","width":1000,"height":325,"caption":"inogic logo"},"image":{"@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#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\/sarika\/#author","url":"https:\/\/www.inogic.com\/blog\/author\/sarika\/","name":"Inogic","image":{"@type":"ImageObject","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/f7e3157d3c9d28231b0a67ff18cc6445c87e889473ae03080f7026c5482ce860?s=96&d=mm&r=g","width":96,"height":96,"caption":"Inogic"}},{"@type":"WebPage","@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#webpage","url":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/","name":"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks","description":"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/#breadcrumblist"},"author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/sarika\/#author"},"creator":{"@id":"https:\/\/www.inogic.com\/blog\/author\/sarika\/#author"},"datePublished":"2023-09-07T16:07:09+05:30","dateModified":"2025-07-21T12:33:14+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":"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks","og:description":"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference","og:url":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/","og:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg","og:image:secure_url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg","og:image:width":719,"og:image:height":255,"article:published_time":"2023-09-07T10:37:09+00:00","article:modified_time":"2025-07-21T07:03:14+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"How to use the dateDifference() function in Power Automate - Microsoft Dynamics 365 CRM Tips and Tricks","twitter:description":"Power Automate has recently introduced an innovative function aimed at calculating the difference between two dates. However, finding the difference between two dates in Power Automate was quite complex, and with the recent introduction of dateDifference() function, Microsoft has eased that out. In this blog, we will see how the process of calculating the difference","twitter:creator":"@inogic","twitter:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg","twitter:label1":"Written by","twitter:data1":"Inogic","twitter:label2":"Est. reading time","twitter:data2":"2 minutes"},"aioseo_meta_data":{"post_id":"35932","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"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":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":true,"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":"BlogPosting","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":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2023-09-07 10:30:49","updated":"2025-07-21 07:05:24","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\/power-automate\/\" title=\"Power Automate\">Power Automate<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to use the dateDifference() function in Power Automate\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.inogic.com\/blog"},{"label":"Power Automate","link":"https:\/\/www.inogic.com\/blog\/category\/power-automate\/"},{"label":"How to use the dateDifference() function in Power Automate","link":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/"}],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/35932","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=35932"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/35932\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=35932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=35932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=35932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}