{"id":31492,"date":"2018-04-21T15:47:47","date_gmt":"2018-04-21T15:47:47","guid":{"rendered":"https:\/\/ampscript.guide\/formatdate\/"},"modified":"2024-10-27T18:04:28","modified_gmt":"2024-10-27T18:04:28","slug":"formatdate","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/formatdate\/","title":{"rendered":"FormatDate"},"content":{"rendered":"

FormatDate<\/h2>\n

This function formats a date\/time string in the specified format pattern and locale.<\/p>\n

Arguments<\/h3>\n

FormatDate(1,2,3,4)<\/code><\/p>\n\n\n\n\n\n\n\n\n
Ordinal<\/th>\nType<\/th>\nRequired<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nString<\/td>\nTrue<\/td>\nThe date string to format<\/td>\n<\/tr>\n
2<\/td>\nString<\/td>\nTrue<\/td>\nThe output date format pattern (see table below for valid values)<\/td>\n<\/tr>\n
3<\/td>\nString<\/td>\nFalse<\/td>\nThe output time format pattern (see table below for valid values)<\/td>\n<\/tr>\n
4<\/td>\nString<\/td>\nFalse<\/td>\nThe ISO locale code for the output<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

These are the valid format patterns, given a date of 2017-09-15T16:07:08.1230000-06:00<\/code>:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Element<\/th>\nFormat Pattern<\/th>\nOutput<\/th>\n<\/tr>\n<\/thead>\n
Long<\/td>\nl<\/td>\nFriday, September 15, 2017<\/td>\n<\/tr>\n
Short Date<\/td>\ns<\/td>\n9\/15\/2017<\/td>\n<\/tr>\n
Month Year<\/td>\nY<\/td>\nSeptember 2017<\/td>\n<\/tr>\n
Year<\/td>\nYY<\/td>\n17<\/td>\n<\/tr>\n
Year<\/td>\nYYYY<\/td>\n2017<\/td>\n<\/tr>\n
Month<\/td>\nM<\/td>\nSeptember 15<\/td>\n<\/tr>\n
Month<\/td>\nMM<\/td>\n09<\/td>\n<\/tr>\n
Month<\/td>\nMMM<\/td>\nSep<\/td>\n<\/tr>\n
Month<\/td>\nMMMM<\/td>\nSeptember<\/td>\n<\/tr>\n
Day<\/td>\ndd<\/td>\n15<\/td>\n<\/tr>\n
Day<\/td>\ndddd<\/td>\nFri<\/td>\n<\/tr>\n
Day<\/td>\nddddd<\/td>\nFriday<\/td>\n<\/tr>\n
Hour 12-hour<\/td>\nhh<\/td>\n06<\/td>\n<\/tr>\n
Hour 24-hour<\/td>\nHH<\/td>\n16<\/td>\n<\/tr>\n
Minutes<\/td>\nmm<\/td>\n07<\/td>\n<\/tr>\n
Seconds<\/td>\nss<\/td>\n08<\/td>\n<\/tr>\n
Milliseconds (time only)<\/td>\nMM<\/td>\n123<\/td>\n<\/tr>\n
AM\/PM<\/td>\ntt<\/td>\nPM<\/td>\n<\/tr>\n
Timezone offset<\/td>\nzz<\/td>\n-06<\/td>\n<\/tr>\n
Timezone offset<\/td>\nzzz<\/td>\n-06:00<\/td>\n<\/tr>\n
Short Time<\/td>\ns<\/td>\n4:07 PM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

NOTE: Format patterns are not case-sensitive, but they must be used in the correct pattern argument (for example, both mm<\/code> and MM<\/code> are date and<\/em> time formats).<\/p>\n

NOTE: This function returns lowercase month and day names for non-US culture codes by default.<\/p>\n<\/blockquote>\n

Example<\/h3>\n
%%[\n\nvar @dateString, @timeString, @dateISO, @dateRFC, @dateLong, @dateShort, @frFRDate, @monthYear, @yearShort, @yearFull, @monthNameDay, @monthNumber, @monthShortName, @monthFullName, @dayNumber, @dayShortName, @dayFullName, @hour, @minute, @seconds, @milliseconds, @AMPM, @offsetHours, @offsetHoursMinutes, @timeShort\n\nset @dateString = \"2017-09-15T16:07:08.1230000-06:00\"\nset @timeString = \"16:07:08.123\"\n\nset @dateISO  = FormatDate(@dateString,\"iso\")\nset @dateRFC  = FormatDate(@dateString,\"rfc\")\nset @dateLong  = FormatDate(@dateString,\"l\")\nset @dateShort  = FormatDate(@dateString,\"s\")\nset @frFRDate = properCase(FormatDate(@dateString,\"l\",\"\",\"fr-FR\"))\n\nset @monthYear = FormatDate(@dateString,\"Y\")\nset @yearShort = FormatDate(@dateString,\"YY\")\nset @yearFull = FormatDate(@dateString,\"YYYY\")\nset @monthNameDay = FormatDate(@dateString,\"M\")\nset @monthNumber = FormatDate(@dateString,\"MM\")\nset @monthShortName = FormatDate(@dateString,\"MMM\")\nset @monthFullName = FormatDate(@dateString,\"MMMM\")\nset @dayNumber = FormatDate(@dateString,\"dd\")\nset @dayShortName = FormatDate(@dateString,\"dddd\")\nset @dayFullName = FormatDate(@dateString,\"ddddd\")\n\nset @hour = FormatDate(@timeString,\"\",\"hh\")\nset @minute = FormatDate(@timeString,\"\",\"mm\")\nset @seconds = FormatDate(@timeString,\"\",\"ss\")\nset @milliseconds = FormatDate(@timeString,\"\",\"MMM\")\nset @AMPM = FormatDate(@timeString,\"\",\"tt\")\nset @offsetHours = FormatDate(@dateString,\"zz\")\nset @offsetHoursMinutes = FormatDate(@dateString,\"zzz\")\nset @timeShort = FormatDate(@timeString,\"\",\"s\")\n\n]%%\ndateString: %%=v(@dateString)=%%\n<br>dateISO: %%=v(@dateISO)=%%\n<br>dateRFC: %%=v(@dateRFC)=%%\n<br>dateLong: %%=v(@dateLong)=%%\n<br>dateShort: %%=v(@dateShort)=%%\n<br>frFRDate: %%=v(@frFRDate)=%%\n<br><br>monthYear: %%=v(@monthYear)=%%\n<br>yearShort: %%=v(@yearShort)=%%\n<br>yearFull: %%=v(@yearFull)=%%\n<br>monthNameDay: %%=v(@monthNameDay)=%%\n<br>monthNumber: %%=v(@monthNumber)=%%\n<br>monthShortName: %%=v(@monthShortName)=%%\n<br>monthFullName: %%=v(@monthFullName)=%%\n<br>dayNumber: %%=v(@dayNumber)=%%\n<br>dayShortName: %%=v(@dayShortName)=%%\n<br>dayFullName: %%=v(@dayFullName)=%%\n<br><br>timeString: %%=v(@timeString)=%%\n<br>hour: %%=v(@hour)=%%\n<br>minute: %%=v(@minute)=%%\n<br>seconds: %%=v(@seconds)=%%\n<br>milliseconds: %%=v(@milliseconds)=%%\n<br>AMPM: %%=v(@AMPM)=%%\n<br>offsetHours: %%=v(@offsetHours)=%%\n<br>offsetHoursMinutes: %%=v(@offsetHoursMinutes)=%%\n<br>timeShort: %%=v(@timeShort)=%%<\/code><\/pre>\n
Output<\/h4>\n
dateString: 2017-09-15T16:07:08.1230000-06:00\ndateISO: 2017-09-15T16:07:08.1230000-06:00\ndateRFC: Fri, 15 Sep 2017 16:07:08 GMT\ndateLong: Friday, September 15, 2017\ndateShort: 9\/15\/2017\nfrFRDate: Vendredi 15 Septembre 2017\n\nmonthYear: September 2017\nyearShort: 17\nyearFull: 2017\nmonthNameDay: September 15\nmonthNumber: 09\nmonthShortName: Sep\nmonthFullName: September\ndayNumber: 15\ndayShortName: Fri\ndayFullName: Friday\n\ntimeString: 16:07:08.123\nhour: 16\nminute: 07\nseconds: 08\nmilliseconds: 123\nAMPM: PM\noffsetHours: -06\noffsetHoursMinutes: -06:00\ntimeShort: 4:07 PM<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
FormatDate This function formats a date\/time string in the specified format pattern and locale. Arguments FormatDate(1,2,3,4) Ordinal Type Required Description 1 String True The date string to format 2 String True The output date format pattern (see table below for valid values) 3 String False The output time format pattern (see table below for valid […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"yoast_head":"\nThe AMPscript Guide - FormatDate<\/title>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ampscript.guide\/formatdate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The AMPscript Guide - FormatDate\" \/>\n<meta property=\"og:description\" content=\"FormatDate This function formats a date\/time string in the specified format pattern and locale. Arguments FormatDate(1,2,3,4) Ordinal Type Required Description 1 String True The date string to format 2 String True The output date format pattern (see table below for valid values) 3 String False The output time format pattern (see table below for valid […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ampscript.guide\/formatdate\/\" \/>\n<meta property=\"og:site_name\" content=\"The AMPscript Guide\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-21T15:47:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-27T18:04:28+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ampscript.guide\/#website\",\"url\":\"https:\/\/ampscript.guide\/\",\"name\":\"The AMPscript Guide\",\"description\":\"The Definitive Scripting Manual for Salesforce Marketing Cloud\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ampscript.guide\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ampscript.guide\/formatdate\/#webpage\",\"url\":\"https:\/\/ampscript.guide\/formatdate\/\",\"name\":\"The AMPscript Guide - FormatDate\",\"isPartOf\":{\"@id\":\"https:\/\/ampscript.guide\/#website\"},\"datePublished\":\"2018-04-21T15:47:47+00:00\",\"dateModified\":\"2024-10-27T18:04:28+00:00\",\"author\":{\"@id\":\"https:\/\/ampscript.guide\/#\/schema\/person\/5335042f77731e84f9808aecef25daec\"},\"breadcrumb\":{\"@id\":\"https:\/\/ampscript.guide\/formatdate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ampscript.guide\/formatdate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ampscript.guide\/formatdate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ampscript.guide\/\",\"url\":\"https:\/\/ampscript.guide\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ampscript.guide\/formatdate\/\",\"url\":\"https:\/\/ampscript.guide\/formatdate\/\",\"name\":\"FormatDate\"}}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/ampscript.guide\/#\/schema\/person\/5335042f77731e84f9808aecef25daec\",\"name\":\"dev\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/posts\/31492"}],"collection":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/comments?post=31492"}],"version-history":[{"count":0,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/posts\/31492\/revisions"}],"wp:attachment":[{"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/media?parent=31492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/categories?post=31492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ampscript.guide\/wp-json\/wp\/v2\/tags?post=31492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}