{"id":26042,"date":"2020-12-16T12:56:43","date_gmt":"2020-12-16T12:56:43","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=26042"},"modified":"2022-07-01T14:58:02","modified_gmt":"2022-07-01T09:28:02","slug":"converting-datetime-field-in-a-different-format-in-power-automated-using-formatdatetime-function","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/12\/converting-datetime-field-in-a-different-format-in-power-automated-using-formatdatetime-function\/","title":{"rendered":"Converting DateTime field in a different format in Power Automate using formatDateTime function"},"content":{"rendered":"

Introduction<\/h2>\n

In this blog, we can see how we can convert DateTime type field to the various format using formatDateTime function. Please find the syntax of formatDateTime function:<\/p>\n

formatDateTime(DATE_TIME_VALUE,DATE_TIME_STRING_FORMAT)<\/u><\/em><\/strong><\/p>\n

Scenario:<\/u><\/strong><\/p>\n

One of our clients wanted to see the last modified date and time of individual Account record. Also, he wants to see this modified date and time in specific format such as \u201cMonday 23-Nov-2020 6:24 AM\u201d<\/em><\/strong>.<\/p>\n

Solution: <\/u><\/strong><\/p>\n

We have created one Microsoft Flow which will trigger on Account record update and on update of account record we are get the current Date Time value using utcNow()<\/em><\/strong> function and convert it in to specific format that client wants and finally update formatted date in to current record as shown in below screenshot:<\/p>\n

formatDateTime(utcNow(),’yyyy-MM-ddThh:mm:ss’)<\/u><\/em><\/strong><\/p>\n

\"Converting<\/a><\/p>\n

After run the below flow on update of Account it will take the proper output as show in below screenshot:<\/p>\n

\"Converting<\/a><\/p>\n

Please find below more examples for different date time formats using formatDateTime() function:<\/p>\n

    \n
  1. formatDateTime(utcNow(),’MM\/dd\/yyyy\u00a0h:mm\u00a0tt’)<\/strong><\/li>\n<\/ol>\n

    \"Converting<\/a><\/strong><\/p>\n

      \n
    1. formatDateTime(utcNow(),’dd-MMMM-yyyy\u00a0h:mm\u00a0tt’)<\/strong><\/li>\n<\/ol>\n

      \"Converting<\/a><\/p>\n

        \n
      1. formatDateTime(utcNow(),’dd-MMM-yyyy\u00a0h:mm\u00a0tt’)<\/strong><\/li>\n<\/ol>\n

        \"Converting<\/a><\/p>\n

          \n
        1. formatDateTime(utcNow(),’yyyy-MM-ddThh:mm:ss’)<\/strong><\/li>\n<\/ol>\n

          \"Converting<\/strong><\/p>\n

          Conclusion<\/strong><\/h2>\n

          With help of formatDateTime function we can easily convert DateTime and Date field value into various ISO DateTime formats.<\/p>\n

          One Pic = 1000 words! Analyze data 90% faster with visualization apps!<\/div><\/div><\/h2>\n

          Get optimum visualization of Dynamics 365 CRM data with –<\/em>
          \n          Kanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em>
          \n          Map My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

          Introduction In this blog, we can see how we can convert DateTime type field to the various format using formatDateTime function. Please find the syntax of formatDateTime function: formatDateTime(DATE_TIME_VALUE,DATE_TIME_STRING_FORMAT) Scenario: One of our clients wanted to see the last modified date and time of individual Account record. Also, he wants to see this modified date\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,18,19,24,1985],"tags":[545,592,1975],"class_list":["post-26042","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-dynamics-crm-2016","category-power-automate","tag-dynamics-365-crm","tag-dynamics-crm","tag-power-automate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26042","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=26042"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26042\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=26042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=26042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=26042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}