CINXE.COM
Converting / Parsing Text / Date in Format DD-MMM-YYYY - How To - Make Community
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Converting / Parsing Text / Date in Format DD-MMM-YYYY - How To - Make Community</title> <meta name="description" content="Hi there :blush: I’m getting a Date value from a Google sheet and eventually trying to push into a Monday board. The date is coming (probably) as text in a DD-MMM-YYYY Format e.g. 16-Nov-2023 and I believe Monday needs&hellip;"> <meta name="generator" content="Discourse 3.4.0.beta3-dev - https://github.com/discourse/discourse version 2513339955ebdfa457a5d6126716091110045e37"> <link rel="icon" type="image/png" href="https://europe1.discourse-cdn.com/flex013/uploads/make/optimized/1X/491d7abe4a5782d0c00ef5416223123f9f329cc5_2_32x32.png"> <link rel="apple-touch-icon" type="image/png" href="https://europe1.discourse-cdn.com/flex013/uploads/make/optimized/2X/1/10a95ac83d0e9a182e57d011f160adf09eaadc6d_2_180x180.png"> <meta name="theme-color" media="(prefers-color-scheme: light)" content="#ffffff"> <meta name="theme-color" media="(prefers-color-scheme: dark)" content="#ffffff"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, user-scalable=yes, viewport-fit=cover"> <link rel="canonical" href="https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240" /> <link rel="search" type="application/opensearchdescription+xml" href="https://community.make.com/opensearch.xml" title="Make Community Search"> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/color_definitions_make-light_25_72_155c581e8c7bea79bf13bffba5c32ee5d16fa109.css?__ws=community.make.com" media="all" rel="stylesheet" class="light-scheme"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/automation_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="automation" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/chat_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="chat" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/checklist_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="checklist" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-ai_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-ai" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-akismet_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-akismet" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-data-explorer_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-data-explorer" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-details_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-details" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-gamification_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-gamification" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-lazy-videos_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-lazy-videos" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-local-dates_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-local-dates" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-narrative-bot_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-narrative-bot" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-presence_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-presence" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-reactions_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-reactions" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-solved_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-solved" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-templates_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-templates" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-user-notes_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-user-notes" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/footnote_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="footnote" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/hosted-site_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="hosted-site" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/poll_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="poll" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/spoiler-alert_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="spoiler-alert" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/chat_desktop_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="chat_desktop" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-ai_desktop_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-ai_desktop" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-gamification_desktop_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-gamification_desktop" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/discourse-reactions_desktop_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="discourse-reactions_desktop" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/poll_desktop_b057edda6a7ee228f73b1b6f6aecbdbd41cd15ae.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="poll_desktop" /> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_47_e69d906449194b639a66988413bd66c6d973e521.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="47" data-theme-name="banner styles"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_80_d70ff29e7a6ea3249a40309c259c559547588d41.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="80" data-theme-name="category badge styles"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_78_eacecbf7307c59f001f28f97014726b9e7fc238a.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="78" data-theme-name="category banners"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_85_7b6230f1bf59b4f0669d2d30be6bb2135b1c57b5.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="85" data-theme-name="discotoc"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_22_aab449bbc174074c97445fba5b0b409dfd626aa0.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="22" data-theme-name="discourse clickable topic"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_12_cfda0adbd891fa60c7076b151875d703cf73744d.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="12" data-theme-name="discourse gifs"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_52_f024caffc9a57b067625f197aa1844a4f43e639e.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="52" data-theme-name="discourse-right-sidebar-blocks"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_53_46f861d38c1ebf7f492bf1ceaa856068e5e44816.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="53" data-theme-name="discourse-search-banner"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_55_44f6208fd90900749f992f89f1a456d58932f353.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="55" data-theme-name="extra banners"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_66_333964a640def55e9fe81f7d1624be2d8182b30b.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="66" data-theme-name="featured cards"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_77_239634c4ce247ec1a1a1751fd6e1a68c620382db.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="77" data-theme-name="full width"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_30_41fe7a2fe4efcffa658310a8554a01cc7150652c.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="30" data-theme-name="modern category + group boxes"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_59_773780f414cbe132d032661bf49d76c42e1370b5.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="59" data-theme-name="new topic button"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_73_a6094af9dce80ec6c2e905660ebbf2735a362073.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="73" data-theme-name="panels"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_61_5047db114e50b975ba76a2fdfdef44d36577ea65.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="61" data-theme-name="primary button"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_62_df25f03f6ae2ede861701a03b96b0f7ed2c40088.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="62" data-theme-name="tag banners"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_64_4007d6ee745a12106df0403c9f01dfc08c390898.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="64" data-theme-name="topic thumbnails"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_72_cc410b7cc941c7617f4ff9ba51ea6da6f5261170.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="72" data-theme-name="make community theme"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_70_11955c12e6b1b9b74e25d3419cee10e958e9f664.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="70" data-theme-name="easy footer (show-always)"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_86_70b0e3b6fe50c460b7783e404b298b9656845b26.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="86" data-theme-name="make custom header"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_84_23278f4a2ad7de0224ae84f81e56ecf1ff8fd0c4.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="84" data-theme-name="make custom homepage"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_83_840d9150b02814f0247db2f8914462b40578ffed.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="83" data-theme-name="make custom info banner"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_81_cb8f67922ea51cbdfc6f2581fac8a1118a16a498.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="81" data-theme-name="tag styles"/> <link href="https://dub1.discourse-cdn.com/flex013/stylesheets/desktop_theme_65_7a31342d5a293f7b65bffa6ef6fe612c67767e34.css?__ws=community.make.com" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="65" data-theme-name="versatile showcase"/> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/a330dfbe8a9e42e89bb78dbba3441344f67e6236.js?__ws=community.make.com" data-theme-id="38" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <!-- OneTrust Cookies Consent Notice start for community.make.com --> <script src="https://cdn.cookielaw.org/scripttemplates/otSDKStub.js" type="text/javascript" charset="UTF-8" data-domain-script="35954e2f-a975-4d27-a5f9-b181a5dfd61c" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <!-- OneTrust Cookies Consent Notice end for community.make.com --><script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/05307152db436f7a0bceab32f2c21c96394b5e0e.js?__ws=community.make.com" data-theme-id="71" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/a28165aca479a15f21ba1941e4ce4dd28a0b7862.js?__ws=community.make.com" data-theme-id="83" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <!-- Add this to the </body> section in your theme component --> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/4b52164bcfcb18b975bd84be770530728312fffe.js?__ws=community.make.com" data-theme-id="84" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/83106f8fed60595f731f037ffa030565f970d62e.js?__ws=community.make.com" data-theme-id="86" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <link rel="alternate nofollow" type="application/rss+xml" title="RSS feed of 'Converting / Parsing Text / Date in Format DD-MMM-YYYY'" href="https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240.rss" /> <meta property="og:site_name" content="Make Community" /> <meta property="og:type" content="website" /> <meta name="twitter:card" content="summary" /> <meta name="twitter:image" content="https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png" /> <meta property="og:image" content="https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png" /> <meta property="og:url" content="https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240" /> <meta name="twitter:url" content="https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240" /> <meta property="og:title" content="Converting / Parsing Text / Date in Format DD-MMM-YYYY" /> <meta name="twitter:title" content="Converting / Parsing Text / Date in Format DD-MMM-YYYY" /> <meta property="og:description" content="Hi there 😊 I’m getting a Date value from a Google sheet and eventually trying to push into a Monday board. The date is coming (probably) as text in a DD-MMM-YYYY Format e.g. 16-Nov-2023 and I believe Monday needs YYYY/MM/DD or something similar (I used DD-MM-YYYY in the screenshot below). The problem is that the formatDate Function doesn’t recognized it as a date so i’m getting an Error Any clues on how to format DD-MMM-YYYY text into a date? Many thanks ! 🥸" /> <meta name="twitter:description" content="Hi there 😊 I’m getting a Date value from a Google sheet and eventually trying to push into a Monday board. The date is coming (probably) as text in a DD-MMM-YYYY Format e.g. 16-Nov-2023 and I believe Monday needs YYYY/MM/DD or something similar (I used DD-MM-YYYY in the screenshot below). The problem is that the formatDate Function doesn’t recognized it as a date so i’m getting an Error Any clues on how to format DD-MMM-YYYY text into a date? Many thanks ! 🥸" /> <meta property="og:article:section" content="How To" /> <meta property="og:article:section:color" content="6D00CC" /> <meta property="og:article:tag" content="format-date" /> <meta property="og:article:tag" content="google" /> <meta property="og:article:tag" content="monday" /> <meta name="twitter:label1" value="Reading time" /> <meta name="twitter:data1" value="1 mins 🕑" /> <meta name="twitter:label2" value="Likes" /> <meta name="twitter:data2" value="11 ❤" /> <meta property="article:published_time" content="2023-11-08T13:05:34+00:00" /> <meta property="og:ignore_canonical" content="true" /> <script type="application/ld+json">{"@context":"http://schema.org","@type":"QAPage","name":"Converting / Parsing Text / Date in Format DD-MMM-YYYY","mainEntity":{"@type":"Question","name":"Converting / Parsing Text / Date in Format DD-MMM-YYYY","text":"Hi there :blush:\n\nI’m getting a Date value from a Google sheet and eventually trying to push into a Monday board.\n\nThe date is coming (probably) as text in a DD-MMM-YYYY Format e.g. 16-Nov-2023 and I believe Monday needs YYYY/MM/DD or something similar (I used DD-MM-YYYY in the screenshot below).\n\n<a class=\"lightbox\" href=\"https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png\" data-download-href=\"/uploads/short-url/e62lwpdnI7e41PGucoi7yY5fx8r.png?dl=1\" title=\"image\" rel=\"noopener nofollow ugc\">[…<\/a>","upvoteCount":0,"answerCount":1,"datePublished":"2023-11-08T13:05:34.278Z","author":{"@type":"Person","name":"OmriNyx","url":"https://community.make.com/u/OmriNyx"},"acceptedAnswer":{"@type":"Answer","text":"You need to use parseDate first with the current date format, then formatDate into the date format you want.\n\nformatDate( parseDate(date_string; current_format); new_format )\n\nSee: <a href=\"https://www.make.com/en/help/functions/tokens-for-date-time-formatting\">Date Format Tokens<\/a>","upvoteCount":4,"datePublished":"2023-11-08T13:20:54.256Z","url":"https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240/2","author":{"@type":"Person","name":"samliew","url":"https://community.make.com/u/samliew"}}}}</script> </head> <body class="crawler browser-update"> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/80bf94ecd6faca7e83a2c4c0892d72900de1a60d.js?__ws=community.make.com" data-theme-id="72" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <style> .selected-tag { display: inline-block; padding: 5px 10px; margin: 5px; border-radius: 20px; background-color: #c362e0; color: white; cursor: pointer; } .selected-tag:hover { opacity: 0.7; } .selected-tag::after { content: " x"; } .makeSelectBox { height: 200px !important; } .makeSearchTags { margin-right: 30px; } .input-select-wrapper { display: flex; flex-direction: column; } /* Style for the table */ .topic-table { width: 100%; border-collapse: collapse; border: 1px solid #D691E9; margin-bottom:160px; margin-top:40px; } /* Style for the table header */ .topic-table th { border: 1px solid #D691E9; padding: 10px; text-align: left; } /* Width for Replies and Views headers */ .topic-table th.replies, .topic-table th.views { width: 10%; } /* Style for table cells */ .topic-table td { border: 1px solid #D691E9; padding: 10px; text-align: left; } /* Align Replies and Views values to the right of their columns */ .topic-table td.replies, .topic-table td.views { text-align: right; } /* Alternate row colors */ .topic-table tr:nth-child(even) { background-color: #f2f2f2; } .query-button { background-color: lightgreen; border-radius: 5px; padding: 10px; margin: 10px 0; display: flex; justify-content: space-between; align-items: center; } #backButton { background-color:red; border-radius: 5px; padding:10px; width: 85px; color: white; } #tagsSelect { width: 100%; height: 300px; font-size: larger; background: #FFF; color: #B866FF; border: 1px solid #B866FF; overflow: auto; width: 300px; padding: 10px; } #tagsSelect option { padding: 5px; } #tagsSelect option:checked { background: #B866FF; color: #FFF; } /* Custom scrollbar */ #tagsSelect::-webkit-scrollbar { width: 12px; /* Width of the vertical scrollbar */ } #tagsSelect::-webkit-scrollbar-thumb { background-color: #B866FF; /* Color of the scroll thumb */ border-radius: 6px; /* Radius of the scroll thumb */ } #tagsSelect::-webkit-scrollbar-thumb:hover { background-color: #9248e6; /* Color of the scroll thumb on hover */ } #tagsSelect::-webkit-scrollbar-track { background-color: #FFF; /* Color of the track */ } .makeSearchTags { width: 300px; border-radius: 5px !important; color: black; border-color: #d83ed8; } th.asc::after { content: '▼'; } th.desc::after { content: '▲'; } .nb_elements { position: absolute; margin-top: 20px; } </style> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/17bf2a23734a5b175856ea53654d2236ce2fc066.js?__ws=community.make.com" data-theme-id="75" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <style> .badge-wrapper .badge-category .category-name { margin-top:8px; } #topic-title .discourse-tags .discourse-tag.box { margin-top:8px; } </style> <script defer="" src="https://dub1.discourse-cdn.com/flex013/theme-javascripts/c1b3e34ffe2abfeda142a4f54cdbe21c0c9c5a81.js?__ws=community.make.com" data-theme-id="76" nonce="imsewV2lWUZYJN0WlH4favOHj"></script> <header> <a href="/"> Make Community </a> </header> <div id="main-outlet" class="wrap" role="main"> <div id="topic-title"> <h1> <a href="/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240">Converting / Parsing Text / Date in Format DD-MMM-YYYY</a> </h1> <div class="topic-category" itemscope itemtype="http://schema.org/BreadcrumbList"> <span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"> <a href="/c/how-to/66" class="badge-wrapper bullet" itemprop="item"> <span class='badge-category-bg' style='background-color: #6D00CC'></span> <span class='badge-category clear-badge'> <span class='category-name' itemprop='name'>How To</span> </span> </a> <meta itemprop="position" content="1" /> </span> </div> <div class="topic-category"> <div class='discourse-tags list-tags'> <a href='https://community.make.com/tag/format-date' class='discourse-tag' rel="tag">format-date</a>, <a href='https://community.make.com/tag/google' class='discourse-tag' rel="tag">google</a>, <a href='https://community.make.com/tag/monday' class='discourse-tag' rel="tag">monday</a> </div> </div> </div> <div itemscope itemtype='http://schema.org/DiscussionForumPosting'> <meta itemprop='headline' content='Converting / Parsing Text / Date in Format DD-MMM-YYYY'> <link itemprop='url' href='https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240'> <meta itemprop='datePublished' content='2023-11-08T13:05:34Z'> <meta itemprop='articleSection' content='How To'> <meta itemprop='keywords' content='format-date, google, monday'> <div itemprop='publisher' itemscope itemtype="http://schema.org/Organization"> <meta itemprop='name' content='Make'> <div itemprop='logo' itemscope itemtype="http://schema.org/ImageObject"> <meta itemprop='url' content='https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/9/9916ec16244838bb6998822ea4bd0a34a751f1fc.png'> </div> </div> <div id='post_1' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://community.make.com/u/OmriNyx'><span itemprop='name'>OmriNyx</span></a> </span> <link itemprop="mainEntityOfPage" href="https://community.make.com/t/converting-parsing-text-date-in-format-dd-mmm-yyyy/19240"> <link itemprop="image" href="https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png"> <span class="crawler-post-infos"> <time datetime='2023-11-08T13:05:34Z' class='post-time'> November 8, 2023, 1:05pm </time> <meta itemprop='dateModified' content='2024-06-26T18:59:06Z'> <span itemprop='position'>1</span> </span> </div> <div class='post' itemprop='text'> <p>Hi there <img src="https://emoji.discourse-cdn.com/twitter/blush.png?v=12" title=":blush:" class="emoji" alt=":blush:" loading="lazy" width="20" height="20"></p> <p>I’m getting a Date value from a Google sheet and eventually trying to push into a Monday board.</p> <p>The date is coming (probably) as text in a DD-MMM-YYYY Format e.g. 16-Nov-2023 and I believe Monday needs YYYY/MM/DD or something similar (I used DD-MM-YYYY in the screenshot below).<br> <div class="lightbox-wrapper"><a class="lightbox" href="https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png" data-download-href="/uploads/short-url/e62lwpdnI7e41PGucoi7yY5fx8r.png?dl=1" title="image" rel="noopener nofollow ugc"><img src="https://europe1.discourse-cdn.com/flex013/uploads/make/optimized/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7_2_690x195.png" alt="image" data-base62-sha1="e62lwpdnI7e41PGucoi7yY5fx8r" width="690" height="195" srcset="https://europe1.discourse-cdn.com/flex013/uploads/make/optimized/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7_2_690x195.png, https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png 1.5x, https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62cd292bb2b538ce41d3295f65b98d66c83cd5e7.png 2x" data-dominant-color="F4F2F2"><div class="meta"><svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use href="#far-image"></use></svg><span class="filename">image</span><span class="informations">1021×290 19.1 KB</span><svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use href="#discourse-expand"></use></svg></div></a></div></p> <p>The problem is that the formatDate Function doesn’t recognized it as a date so i’m getting an Error<br> <img src="https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/d/bd897531da8dd91140e5684d74135283a0d1b605.png" alt="image" data-base62-sha1="r2IK7sspqVuYwA169K1MI92eLMp" width="498" height="306"></p> <p>Any clues on how to format DD-MMM-YYYY text into a date?</p> <p>Many thanks ! <img src="https://emoji.discourse-cdn.com/twitter/disguised_face.png?v=12" title=":disguised_face:" class="emoji" alt=":disguised_face:" loading="lazy" width="20" height="20"></p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_2' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://community.make.com/u/samliew'><span itemprop='name'>samliew</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-11-08T13:20:54Z' class='post-time'> November 8, 2023, 1:20pm </time> <meta itemprop='dateModified' content='2023-11-08T13:20:54Z'> <span itemprop='position'>2</span> </span> </div> <div class='post' itemprop='text'> <p>You need to use <code>parseDate</code> first with the current date format, then <code>formatDate</code> into the date format you want.</p> <p><code>formatDate( parseDate(date_string; current_format); new_format )</code></p> <p>See: <a href="https://www.make.com/en/help/functions/tokens-for-date-time-formatting">Date Format Tokens</a></p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="4" /> <span class='post-likes'>4 Likes</span> </div> </div> <div id='post_3' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://community.make.com/u/Joseph_Honig'><span itemprop='name'>Joseph_Honig</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-11-08T13:28:49Z' class='post-time'> November 8, 2023, 1:28pm </time> <meta itemprop='dateModified' content='2023-11-08T13:28:49Z'> <span itemprop='position'>3</span> </span> </div> <div class='post' itemprop='text'> <p>Hi,</p> <p>The <a href="https://try.monday.com/Make" rel="noopener nofollow ugc">monday.com</a> Date format is YYYY-MM-DD</p> <p>Hope this helps</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="2" /> <span class='post-likes'>2 Likes</span> </div> </div> <div id='post_4' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://community.make.com/u/OmriNyx'><span itemprop='name'>OmriNyx</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-11-08T13:29:28Z' class='post-time'> November 8, 2023, 1:29pm </time> <meta itemprop='dateModified' content='2023-11-08T13:29:28Z'> <span itemprop='position'>4</span> </span> </div> <div class='post' itemprop='text'> <p>Wow Sam, amazing as always, it worked !</p> <p>ParseDate to let Make know what is the format, then formatDate to convert to another date format.</p> <p><img src="https://emoji.discourse-cdn.com/twitter/trophy.png?v=12" title=":trophy:" class="emoji only-emoji" alt=":trophy:" loading="lazy" width="20" height="20"> <img src="https://emoji.discourse-cdn.com/twitter/hugs.png?v=12" title=":hugs:" class="emoji only-emoji" alt=":hugs:" loading="lazy" width="20" height="20"></p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="2" /> <span class='post-likes'>2 Likes</span> </div> </div> <div id='post_5' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://community.make.com/u/samliew'><span itemprop='name'>samliew</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-11-08T14:56:50Z' class='post-time'> November 8, 2023, 2:56pm </time> <meta itemprop='dateModified' content='2023-11-08T14:56:50Z'> <span itemprop='position'>5</span> </span> </div> <div class='post' itemprop='text'> <p>If you want to learn more about Make, you can read up in the <a href="https://www.make.com/en/help">Help Center</a>. I also recommend doing the tutorials in the <a href="https://academy.make.com">Make Academy</a>, and learn advanced skills like how to make custom apps to any API in the <a href="https://partnertraining.make.com">Make Partner Training Portal</a> - both have certificates for successful completion.</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="3" /> <span class='post-likes'>3 Likes</span> </div> </div> </div> <div id="related-topics" class="more-topics__list " role="complementary" aria-labelledby="related-topics-title"> <h3 id="related-topics-title" class="more-topics__list-title"> Related topics </h3> <div class="topic-list-container" itemscope itemtype='http://schema.org/ItemList'> <meta itemprop='itemListOrder' content='http://schema.org/ItemListOrderDescending'> <table class='topic-list'> <thead> <tr> <th>Topic</th> <th></th> <th class="replies">Replies</th> <th class="views">Views</th> <th>Activity</th> </tr> </thead> <tbody> <tr class="topic-list-item" id="topic-list-item-25114"> <td class="main-link" itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'> <meta itemprop='position' content='1'> <span class="link-top-line"> <a itemprop='url' href='https://community.make.com/t/converting-a-date-from-1-format-to-another/25114' class='title raw-link raw-topic-link'>Converting a date from 1 format to another</a> </span> <div class="link-bottom-line"> <a href='/c/how-to/66' class='badge-wrapper bullet'> <span class='badge-category-bg' style='background-color: #6D00CC'></span> <span class='badge-category clear-badge'> <span class='category-name'>How To</span> </span> </a> <div class="discourse-tags"> <a href='https://community.make.com/tag/mapping' class='discourse-tag'>mapping</a> , <a href='https://community.make.com/tag/date-time-functions' class='discourse-tag'>date-time-functions</a> </div> </div> </td> <td class="replies"> <span class='posts' title='posts'>4</span> </td> <td class="views"> <span class='views' title='views'>2956</span> </td> <td> February 13, 2024 </td> </tr> <tr class="topic-list-item" id="topic-list-item-16420"> <td class="main-link" itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'> <meta itemprop='position' content='2'> <span class="link-top-line"> <a itemprop='url' href='https://community.make.com/t/formatting-dates-inside-google-sheets/16420' class='title raw-link raw-topic-link'>Formatting dates inside Google Sheets</a> </span> <div class="link-bottom-line"> <a href='/c/how-to/66' class='badge-wrapper bullet'> <span class='badge-category-bg' style='background-color: #6D00CC'></span> <span class='badge-category clear-badge'> <span class='category-name'>How To</span> </span> </a> <div class="discourse-tags"> <a href='https://community.make.com/tag/google-sheets' class='discourse-tag'>google-sheets</a> </div> </div> </td> <td class="replies"> <span class='posts' title='posts'>8</span> </td> <td class="views"> <span class='views' title='views'>1154</span> </td> <td> October 15, 2023 </td> </tr> <tr class="topic-list-item" id="topic-list-item-24297"> <td class="main-link" itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'> <meta itemprop='position' content='3'> <span class="link-top-line"> <a itemprop='url' href='https://community.make.com/t/format-date-always-returning-1-20-1970/24297' class='title raw-link raw-topic-link'>Format Date always Returning 1/20/1970</a> </span> <div class="link-bottom-line"> <a href='/c/how-to/66' class='badge-wrapper bullet'> <span class='badge-category-bg' style='background-color: #6D00CC'></span> <span class='badge-category clear-badge'> <span class='category-name'>How To</span> </span> </a> <div class="discourse-tags"> <a href='https://community.make.com/tag/google-sheets' class='discourse-tag'>google-sheets</a> </div> </div> </td> <td class="replies"> <span class='posts' title='posts'>2</span> </td> <td class="views"> <span class='views' title='views'>887</span> </td> <td> January 30, 2024 </td> </tr> <tr class="topic-list-item" id="topic-list-item-50120"> <td class="main-link" itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'> <meta itemprop='position' content='4'> <span class="link-top-line"> <a itemprop='url' href='https://community.make.com/t/formatting-dates-from-different-apps-in-a-scenario/50120' class='title raw-link raw-topic-link'>Formatting dates from different apps in a scenario</a> </span> <div class="link-bottom-line"> <a href='/c/how-to/66' class='badge-wrapper bullet'> <span class='badge-category-bg' style='background-color: #6D00CC'></span> <span class='badge-category clear-badge'> <span class='category-name'>How To</span> </span> </a> <div class="discourse-tags"> <a href='https://community.make.com/tag/functions' class='discourse-tag'>functions</a> , <a href='https://community.make.com/tag/mapping' class='discourse-tag'>mapping</a> </div> </div> </td> <td class="replies"> <span class='posts' title='posts'>4</span> </td> <td class="views"> <span class='views' title='views'>35</span> </td> <td> September 5, 2024 </td> </tr> <tr class="topic-list-item" id="topic-list-item-16354"> <td class="main-link" itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'> <meta itemprop='position' content='5'> <span class="link-top-line"> <a itemprop='url' href='https://community.make.com/t/wrong-formatdate/16354' class='title raw-link raw-topic-link'>Wrong formatDate</a> </span> <div class="link-bottom-line"> <a href='/c/how-to/66' class='badge-wrapper bullet'> <span class='badge-category-bg' style='background-color: #6D00CC'></span> <span class='badge-category clear-badge'> <span class='category-name'>How To</span> </span> </a> <div class="discourse-tags"> <a href='https://community.make.com/tag/date-time-functions' class='discourse-tag'>date-time-functions</a> , <a href='https://community.make.com/tag/format-date' class='discourse-tag'>format-date</a> </div> </div> </td> <td class="replies"> <span class='posts' title='posts'>5</span> </td> <td class="views"> <span class='views' title='views'>565</span> </td> <td> October 6, 2023 </td> </tr> </tbody> </table> </div> </div> </div> <footer class="container wrap"> <nav class='crawler-nav'> <ul> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/' itemprop="url">Home </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/categories' itemprop="url">Categories </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/guidelines' itemprop="url">Guidelines </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/tos' itemprop="url">Terms of Service </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='https://www.make.com/en/privacy-notice' itemprop="url">Privacy Policy </a> </span> </li> </ul> </nav> <p class='powered-by-link'>Powered by <a href="https://www.discourse.org">Discourse</a>, best viewed with JavaScript enabled</p> </footer> <div class="buorg"><div>Unfortunately, <a href="https://www.discourse.org/faq/#browser">your browser is unsupported</a>. Please <a href="https://browsehappy.com">switch to a supported browser</a> to view rich content, log in and reply.</div></div> </body> </html>