{"id":8224,"date":"2025-08-26T18:36:40","date_gmt":"2025-08-26T18:36:40","guid":{"rendered":"https:\/\/powergi.net\/?p=8224"},"modified":"2025-09-15T19:03:06","modified_gmt":"2025-09-15T19:03:06","slug":"format-datetime-in-power-automate","status":"publish","type":"post","link":"https:\/\/powergi.net\/es\/blog\/format-datetime-in-power-automate\/","title":{"rendered":"Formato de fecha y hora en Power Automate"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8224\" class=\"elementor elementor-8224\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5803b0b e-flex e-con-boxed e-con e-parent\" data-id=\"5803b0b\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f83c6ef elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"f83c6ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"marker_view\":\"numbers\",\"minimize_box\":\"yes\",\"minimized_on\":\"tablet\",\"hierarchical_view\":\"yes\",\"min_height\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]}}' data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__f83c6ef\" aria-expanded=\"true\" aria-label=\"Abrir la tabla de contenidos\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__f83c6ef\" aria-expanded=\"true\" aria-label=\"Cerrar la tabla de contenidos\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__f83c6ef\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e03f061 elementor-widget elementor-widget-text-editor\" data-id=\"e03f061\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Working with dates and times is really common for many types of automations. Data often comes in one format but needs to be displayed, stored, or compared in another. That\u2019s when format datetime in Power Automate becomes really important .\u00a0<\/p><p>There are basically two ways to format dates or datetime stamps in Power Automate:<\/p><p>Convert time zone action: this is a combination of converting time zone + formatting. If we want to only apply format, both the source and destination time zone can be the same. Time unit will be the final format in which the date will be displayed. This action is not so flexible as directly using the formatDateTime but also be very useful for some scenarios.<\/p><p><img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cac36b7.png\" alt=\"\"><\/p><p><span style=\"font-family: Aptos, sans-serif; font-size: 11pt; font-style: inherit; font-weight: inherit;\">Format Date Time function: this lets you transform a datetime value into a specific string format. It\u2019s a very robust and flexible approach as many out-of-the-box<br>and custom formats can be applied, even considering language. This blog will focus on the use of this PowerFx function.<\/span><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cb13bed.png\" alt=\"\"><\/p><p><span style=\"font-size: 11pt; line-height: 107%; font-family: Aptos, sans-serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">When we will re-use the formatted date more than once in the workflow it\u2019s recommended to store the formatted date in a variable or compose action, this way we calculate the format only once, and re-use it as many times as required.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-218440b elementor-widget elementor-widget-heading\" data-id=\"218440b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What is the formatDateTime function in Power Automate?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7213847 elementor-widget elementor-widget-text-editor\" data-id=\"7213847\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The <strong>formatDateTime <\/strong>function in Power Automate is used to take a datetime value and return it as a string in the format you specify.<\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7283\" class=\"elementor elementor-7283\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Is your business ready for automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Automate processes with Microsoft Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/es\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div><p>Some examples of when to use include:<\/p><ul><li>Display dates in a user-friendly way, for example show August 17, 2025 instead of 2025-08-17T22:30:00Z.<\/li><li>Standardize dates before saving them, for example, always store as yyyy-MM-dd).<\/li><li>Show dates and\/or times in a specific language.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5bf8286 elementor-widget elementor-widget-heading\" data-id=\"5bf8286\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">When to use formatDateTime vs convertTimeZone?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d82e4dc elementor-widget elementor-widget-text-editor\" data-id=\"d82e4dc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The convertTimeZone function is also really useful, but it serves a different purpose: <strong>change the datetime value<\/strong> into a <strong>different time zone<\/strong>.\u00a0 formatDateTime to change how the date looks (formatting for emails, file names, etc), convertTimeZone is about changing the actual date\/time (from one source datetime stamp to a different one \u2013 such as converting UTC to Central America time in El Salvador).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0479754 elementor-widget elementor-widget-code-highlight\" data-id=\"0479754\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>formarDateTime example\n\nformatDateTime(utcNow(), 'dddd, MMMM dd','en-US')\n\nResult: show current UTC datetime in this format: Sunday, August 17.\n\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nconvertTimeZone example\n\nconvertTimeZone(utcNow(), 'UTC', 'Central Standard Time')\n\nResult: convert current UTC datetime to CST time.<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5fc2c5a elementor-widget elementor-widget-text-editor\" data-id=\"5fc2c5a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Use formatDateTime to change how the date looks (formatting for emails, file names, etc), convertTimeZone is about changing the actual date\/time (from one source datetime stamp to a different one \u2013 such as converting UTC to Central America time in El Salvador).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-477afd2 elementor-widget elementor-widget-heading\" data-id=\"477afd2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Key parameters: timestamp, format string, locale<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e556635 elementor-widget elementor-widget-text-editor\" data-id=\"e556635\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The\u00a0formatDateTime function has three parameters. Two are optional, but knowing all three helps you get exactly the output you want:<\/p><p><img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cb44928.png\" alt=\"\"><\/p><p>\u00a0<\/p><ol><li><strong>Timestamp (required)<\/strong><\/li><\/ol><ul><li>The datetime value you want to format.<\/li><li>Can come from built-in functions (utcNow()), dynamic content (like Created date from SharePoint as shown in the screenshot above), or other expressions.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e7be740 elementor-widget elementor-widget-code-highlight\" data-id=\"e7be740\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>formatDateTime(utcNow(), 'yyyy-MM-dd')\r\nResult:\r\n2025-08-17\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-581e65e elementor-widget elementor-widget-text-editor\" data-id=\"581e65e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"2\"><li><strong> format string (optional)<\/strong><\/li><\/ol><ul><li>Defines how the datetime should be displayed.<\/li><li>If not provided, the function defaults to <strong style=\"font-size: 16px;\">ISO 8601 format<\/strong><span style=\"font-size: 16px;\">: 2025-08-17T22:30:00Z.<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bf790c1 elementor-widget elementor-widget-code-highlight\" data-id=\"bf790c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp> formatDateTime(utcNow(), 'dddd, MMM dd')\r\nResult:\r\nSunday, Aug 17\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9558589 elementor-widget elementor-widget-text-editor\" data-id=\"9558589\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Some common formats:<\/p><table class=\"MsoNormalTable\" style=\"border-collapse: collapse; mso-yfti-tbllook: 1184;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"mso-yfti-irow: 0; mso-yfti-firstrow: yes; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><b>Format string<\/b><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><b>Example output<\/b><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><b>Meaning<\/b><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 1; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">yyyy-MM-dd<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">8\/17\/2025<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Year-Month-Day<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 2; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">MM\/dd\/yyyy<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">8\/17\/2025<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Month\/Day\/Year (US format)<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 3; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">dd\/MM\/yyyy<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">17\/08\/2025<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Day\/Month\/Year (EU format)<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 4; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">dddd, MMMM dd<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Sunday, August 17<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Full day + full month name<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 5; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">ddd, MMM dd<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Sun, Aug 17<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Abbreviated day + abbreviated month<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 6; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">HH:mm<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">22:30<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">24-hour time<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 7; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">hh:mm tt<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">10:30 PM<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">12-hour time with AM\/PM<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 8; height: 38.5pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 38.5pt;\" valign=\"top\"><p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">yyyy-MM-ddTHH:mm:ssZ<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 38.5pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">2025-08-17T22:30:00Z<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 38.5pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">ISO 8601 standard<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 9; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">MMMM yyyy<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Aug-25<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Month + Year<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 10; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">ddd<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Sun<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Day of week (short)<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 11; mso-yfti-lastrow: yes; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">dddd<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Sunday<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Day of week (full)<\/span><\/p><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83d46b4 elementor-widget elementor-widget-text-editor\" data-id=\"83d46b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Short format specifiers can be used as well:<\/span><\/p><p>\u00a0<\/p><table style=\"border-collapse: collapse; mso-yfti-tbllook: 1184;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"mso-yfti-irow: 0; mso-yfti-firstrow: yes; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Format string<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Meaning<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Example<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 1; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">d<\/span><\/p><\/td><td style=\"border: none; border-bottom: solid #D1D1D1 1.0pt; mso-border-bottom-alt: solid #D1D1D1 .5pt; padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Short date pattern.<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">6\/15\/2009<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 2; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">D<\/span><\/p><\/td><td style=\"border: none; border-bottom: solid #D1D1D1 1.0pt; mso-border-top-alt: solid #D1D1D1 .5pt; mso-border-bottom-alt: solid #D1D1D1 .5pt; padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Long date pattern<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Monday, June 15, 2009<\/span><\/p><\/td><\/tr><tr style=\"mso-yfti-irow: 3; mso-yfti-lastrow: yes; height: 24.25pt;\"><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">G<\/span><\/p><\/td><td style=\"border: none; mso-border-top-alt: solid #D1D1D1 .5pt; padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">General date\/time pattern (long<br>time)<\/span><\/p><\/td><td style=\"padding: 5.0pt 5.0pt 5.0pt 5.0pt; height: 24.25pt;\" valign=\"top\"><p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">6\/15\/2009 1:45:30 PM (en-US)<\/span><\/p><\/td><\/tr><\/tbody><\/table><p class=\"MsoNormal\"><span lang=\"EN-US\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">The full list of formats can be found here: <\/span><a href=\"https:\/\/learn.microsoft.com\/en-us\/dotnet\/standard\/base-types\/standard-date-and-time-format-strings\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/dotnet\/standard\/base-types\/standard-date-and-time-format-strings<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d7e99e9 elementor-widget elementor-widget-text-editor\" data-id=\"d7e99e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"3\"><li><strong> locale (optional)<\/strong><\/li><\/ol><ul><li>Sets the <strong>language and cultural format<\/strong> for the output.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1017fd4 elementor-widget elementor-widget-code-highlight\" data-id=\"1017fd4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp> formatDateTime(\r\nutcNow(),\r\n \t'dddd, MMMM dd',\r\n \t'es-ES'\r\n)\r\nResult:  domingo, agosto 17\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-beb4043 elementor-widget elementor-widget-text-editor\" data-id=\"beb4043\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Common locale codes:<\/strong><\/p><p>en-US \u2192 English (United States)<\/p><p>es-ES \u2192 Spanish (Spain)<\/p><p>fr-FR \u2192 French (France)<\/p><p>de-DE \u2192 German (Germany)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4cb15e4 elementor-widget elementor-widget-heading\" data-id=\"4cb15e4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Examples using formatDateTime<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-313aece elementor-widget elementor-widget-heading\" data-id=\"313aece\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Format only date (e.g., \u2018yyyy-MM-dd\u2019)<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f99abe9 elementor-widget elementor-widget-text-editor\" data-id=\"f99abe9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Display just the date in a standard numeric format.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-abeb8e5 elementor-widget elementor-widget-code-highlight\" data-id=\"abeb8e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>formatDateTime(\r\n  outputs('Get_item')?['body\/Created'],\r\n  'yyyy-MM-dd'\r\n  )\r\n\r\nOutput: 2025-08-17\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d60b8a elementor-widget elementor-widget-heading\" data-id=\"8d60b8a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Format date and time (e.g., \u2018MM\/dd\/yyyy hh:mm tt\u2019)<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f42c423 elementor-widget elementor-widget-text-editor\" data-id=\"f42c423\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Show both date and 12-hour time with AM\/PM<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8863104 elementor-widget elementor-widget-heading\" data-id=\"8863104\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Using day-of-week or month names (\u2018dddd\u2019, \u2018MMMM\u2019)<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8dcace0 elementor-widget elementor-widget-code-highlight\" data-id=\"8dcace0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>formatDateTime(\r\n  outputs('Get_item')?['body\/Created'],\r\n  'MM\/dd\/yyyy hh:mm tt'\r\n  )\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa05bef elementor-widget elementor-widget-text-editor\" data-id=\"fa05bef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Include full day or month names for a user-friendly display.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8fde1c0 elementor-widget elementor-widget-code-highlight\" data-id=\"8fde1c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>formatDateTime(\n\n\u00a0\u00a0outputs('Get_item')?['body\/Created'],\n\n\u00a0\u00a0'dddd'\n\n\u00a0\u00a0)\n\nOutput: Sunday\n\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nformatDateTime(\n\n\u00a0\u00a0outputs('Get_item')?['body\/Created'],\n\n\u00a0\u00a0'MMMM'\n\n\u00a0\u00a0)\n\nOutput: August<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7686e1 elementor-widget elementor-widget-heading\" data-id=\"a7686e1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Show date format in a specific language.<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f51dd69 elementor-widget elementor-widget-text-editor\" data-id=\"f51dd69\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Use the locale parameter to display the date in another language.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c6fa39 elementor-widget elementor-widget-code-highlight\" data-id=\"7c6fa39\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>formatDateTime(\n\n\u00a0\u00a0utcNow(),\n\n\u00a0\u00a0'dddd, MMMM dd',\n\n\u00a0\u00a0'es-ES'\n\n\u00a0\u00a0)\n\nOutput: domingo, agosto 17<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6347c5 elementor-widget elementor-widget-heading\" data-id=\"d6347c5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Dynamic datetime formatting in real-world flows<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f41c8e elementor-widget elementor-widget-text-editor\" data-id=\"0f41c8e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>It\u2019s really common to want to show dates in specific formats when working with Power Automate, for example when we\u2019re saving files in SharePoint, sending emails or requesting an approval.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e073af elementor-widget elementor-widget-heading\" data-id=\"4e073af\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Naming files or folders with formatted dates<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b31067 elementor-widget elementor-widget-text-editor\" data-id=\"8b31067\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>We can pass a dynamic date in the File Name field of a create file action, this way the file will be saved with the date in the format that we specify in the second parameter of the formatDateTime action:<\/p><p><img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cb6a842.png\" alt=\"\"><\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7531\" class=\"elementor elementor-7531\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Are you ready to discover the joy of automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Whether you have a project in mind or just want to know how we can help, we\u2019re happy to have a conversation<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/es\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div><p>You can also save the results in a compose action or a variable and reference in the following actions.<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cbb1860.png\" alt=\"\"><\/p><p>In this example, we\u2019re using the result of the compose action (which has a formatted date) in the file name:<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cbcc787.png\" alt=\"\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9932e9b elementor-widget elementor-widget-heading\" data-id=\"9932e9b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Formatting dates for notifications or approvals<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c854ab6 elementor-widget elementor-widget-text-editor\" data-id=\"c854ab6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When sending emails, Teams messages, or approval requests, it\u2019s really valuable to include dates in a friendly format.<img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8224-6a4450cc2e953.png\" alt=\"\" style=\"font-size: 1rem;\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fefd8a5 elementor-widget elementor-widget-heading\" data-id=\"fefd8a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Dealing with null or empty datetime values<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae1e86b elementor-widget elementor-widget-text-editor\" data-id=\"ae1e86b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Datetime fields are not always populated. Using formatDateTime on a null or empty value will cause a flow to fail<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41aea23 elementor-widget elementor-widget-heading\" data-id=\"41aea23\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">H3: Null values<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1180d13 elementor-widget elementor-widget-code-highlight\" data-id=\"1180d13\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>Use the coalesce() function to provide a default value if the date is null\r\nformatDateTime(\r\n  coalesce(\r\n    outputs('Get_item')?['body\/DueDate'],\r\n    utcNow()\r\n    ),\r\n    'yyyy-MM-dd'\r\n  )\r\nIn above example, the expression will check if the column \u201cDueDate\u201d has a value or not, and if null, it will use utcNow datetime stamp. This will prevent the workflow to fail.\r\n\r\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n\r\nAnother alternative is to check if the value is null and perform an action based on this:\r\nif(\r\n  equals(\r\n    outputs('Get_item')?['body\/DueDate']\r\n    ,null),\r\n    '',\r\n    formatDateTime(\r\n      outputs('Get_item')?['body\/DueDate],\r\n      'dddd, MMMM dd yyyy'\r\n      )\r\n)\r\nIn above example, if the \u201cDueDate\u201d is null, then the expression will return an empty string (\u2018\u2019), and if not, it will format the date.\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1e4dbb elementor-widget elementor-widget-heading\" data-id=\"e1e4dbb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Get custom Power Automate solutions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cc9d69 elementor-widget elementor-widget-text-editor\" data-id=\"5cc9d69\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Formatting dates and times correctly is just one example of the many actions required when building flows. From handling <strong>null values<\/strong> to creating <strong>dynamic expressions for <\/strong>, <strong>notifications<\/strong> or file creations, we can help your team design and create great workflows. <a href=\"https:\/\/powergi.net\/contact\/\">Contact us <\/a>today and let\u2019s talk about our <a href=\"https:\/\/powergi.net\/power-automate-consulting-services\/\">Power Automate development services<\/a> can help!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents Working with dates and times is really common for many types of automations. Data often comes in one format but needs to be displayed, stored, or compared in another. That\u2019s when format datetime in Power Automate becomes really important . There are basically two ways to format dates or datetime stamps in [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":8251,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"","footnotes":""},"categories":[172,85],"tags":[],"class_list":["post-8224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dpa","category-power-automate-cat"],"glossary_letter":"","rank_math_title":"How to format DateTime in Power Automate? - Power GI","rank_math_description":"Learn how to format datetime in Power Automate using formatDateTime. Practical examples, syntax, use cases, and common troubleshooting tips.","rank_math_focus_keyword":"Format DateTime in Power Automate","_links":{"self":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/8224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/comments?post=8224"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/8224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media\/8251"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media?parent=8224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/categories?post=8224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/tags?post=8224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}