{"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":"2026-08-19T11:13:31","modified_gmt":"2026-08-19T05:43:31","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<h2><strong>Scenario:<\/strong><\/h2>\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>\n<h3>Creation of Account.<\/h3>\n<\/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>\n<h3>Add an action \u201cUpdate a row\u201d to show the remaining expiration days.<\/h3>\n<\/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>\n<h3>Adding the datedifference() function in the Expiry days field.<\/h3>\n<\/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<h2><strong>Expression \u2013 <\/strong><\/h2>\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<h2><strong>Expression:<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p>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 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.\" \/>\n\t<meta name=\"robots\" content=\"max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n\t<meta name=\"author\" content=\"Piyush\"\/>\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) 5.0.0.1\" \/>\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=\"Power Automate dateDifference() Function: Calculate Date Difference\" \/>\n\t\t<meta property=\"og:description\" content=\"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.\" \/>\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=\"2026-08-19T05:43:31+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=\"Power Automate dateDifference() Function: Calculate Date Difference\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.\" \/>\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=\"Piyush\" \/>\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\":\"Power Automate dateDifference() Function: Calculate Date Difference\",\"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\":\"2026-08-19T11:13:31+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\":\"Piyush\",\"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\":\"Piyush\"}},{\"@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\":\"Power Automate dateDifference() Function: Calculate Date Difference\",\"description\":\"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.\",\"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\":\"2026-08-19T11:13:31+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":"Power Automate dateDifference() Function: Calculate Date Difference","description":"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.","canonical_url":"https:\/\/www.inogic.com\/blog\/2023\/09\/how-to-use-the-datedifference-function-in-power-automate\/","robots":"max-snippet:-1, max-image-preview:large, max-video-preview:-1","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":"Power Automate dateDifference() Function: Calculate Date Difference","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":"2026-08-19T11:13:31+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":"Piyush","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":"Piyush"}},{"@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":"Power Automate dateDifference() Function: Calculate Date Difference","description":"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.","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":"2026-08-19T11:13:31+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":"Power Automate dateDifference() Function: Calculate Date Difference","og:description":"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.","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":"2026-08-19T05:43:31+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"Power Automate dateDifference() Function: Calculate Date Difference","twitter:description":"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.","twitter:creator":"@inogic","twitter:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/09\/1Power-Automate.jpeg","twitter:label1":"Written by","twitter:data1":"Piyush","twitter:label2":"Est. reading time","twitter:data2":"2 minutes"},"aioseo_meta_data":{"post_id":"35932","title":"Power Automate dateDifference() Function: Calculate Date Difference","description":"Learn how to use the dateDifference() function in Power Automate to calculate the difference between two dates, including remaining days with examples.","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":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2023-09-07 10:30:49","updated":"2026-08-19 06:20:13","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":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}]}}