{"id":2580,"date":"2013-11-11T11:59:00","date_gmt":"2013-11-11T11:59:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2013\/11\/11\/powertip-use-powershell-to-format-dates\/"},"modified":"2013-11-11T11:59:00","modified_gmt":"2013-11-11T11:59:00","slug":"powertip-use-powershell-to-format-dates","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/powertip-use-powershell-to-format-dates\/","title":{"rendered":"PowerTip: Use PowerShell to Format Dates"},"content":{"rendered":"<p><strong>Summary<\/strong>: Learn how to use Windows PowerShell to format dates.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" alt=\"Hey, Scripting Guy! Question\">&nbsp;How can I discover the formats that are available to use in Windows PowerShell when I format date and time information?<\/p>\n<p style=\"padding-left: 30px\"><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" alt=\"Hey, Scripting Guy! Answer\">&nbsp;One way is to keep this script handy and run it when you have a date formatting issue to output common formats:<\/p>\n<p style=\"padding-left: 120px\">&#8220;d ShortDatePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format d )<\/p>\n<p style=\"padding-left: 120px\">&#8220;D LongDatePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format D )<\/p>\n<p style=\"padding-left: 120px\">&#8220;f Full date and time (long date and short time)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format f )<\/p>\n<p style=\"padding-left: 120px\">&#8220;F FullDateTimePattern (long date and long time)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format F )<\/p>\n<p style=\"padding-left: 120px\">&#8220;g General (short date and short time)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp; {0} &#8221; -f (get-date -Format g )<\/p>\n<p style=\"padding-left: 120px\">&#8220;G General (short date and long time)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format G )<\/p>\n<p style=\"padding-left: 120px\">&#8220;m MonthDayPattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format m )<\/p>\n<p style=\"padding-left: 120px\">&#8220;M MonthDayPattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format M )<\/p>\n<p style=\"padding-left: 120px\">&#8220;o Round-trip date\/time pattern always uses the invariant culture&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format o )<\/p>\n<p style=\"padding-left: 120px\">&#8220;O Round-trip date\/time pattern always uses the invariant culture&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format O )<\/p>\n<p style=\"padding-left: 120px\">&#8220;r RFC1123Pattern always uses the invariant culture&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format r )<\/p>\n<p style=\"padding-left: 120px\">&#8220;R RFC1123Pattern always uses the invariant culture&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format R )<\/p>\n<p style=\"padding-left: 120px\">&#8220;s SortableDateTimePattern always uses the invariant culture&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format s )<\/p>\n<p style=\"padding-left: 120px\">&#8220;t ShortTimePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format t )<\/p>\n<p style=\"padding-left: 120px\">&#8220;T LongTimePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp; {0} &#8221; -f (get-date -Format T )<\/p>\n<p style=\"padding-left: 120px\">&#8220;u UniversalSortableDateTimePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format u )<\/p>\n<p style=\"padding-left: 120px\">&#8220;U Full date and time &#8211; universal time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format u )<\/p>\n<p style=\"padding-left: 120px\">&#8220;y YearMonthPattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format y )<\/p>\n<p style=\"padding-left: 120px\">&#8220;Y YearMonthPattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format Y )<\/p>\n<p style=\"padding-left: 120px\">&nbsp;<\/p>\n<p style=\"padding-left: 120px\">&#8220;`nCustom Formats&#8221;<\/p>\n<p style=\"padding-left: 120px\">&#8220;d\/M\/y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format d\/M\/y )<\/p>\n<p style=\"padding-left: 120px\">&#8220;%d\/%M\/yy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format d\/M\/yy )<\/p>\n<p style=\"padding-left: 120px\">&#8220;dd\/MM\/yyyy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format dd\/MM\/yyyyy )<\/p>\n<p style=\"padding-left: 120px\">&#8220;dd\/MM\/yyyy %g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp; {0} &#8221; -f (get-date -Format &#8216;dd\/MM\/yyyyy %g&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dd\/MM\/yyyy gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dd\/MM\/yyyyy gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd\/MM\/yyyy gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd\/MM\/yyyyy gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd\/MM\/yyyy %h:m:s tt gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd\/MM\/yyyyy %h:m:s tt gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd\/MM\/yyyy hh:mm:s tt gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd\/MM\/\nyyyyy hh:mm:s tt gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd\/MM\/yyyy HH:mm:s gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd\/MM\/yyyyy HH:mm:s gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd\/MM\/yyyy HH:mm:s.ffff gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd\/MM\/yyyyy HH:mm:s.ffff gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd MMM yyyy HH:mm:s.ffff gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd MMM yyyyy HH:mm:s.ffff gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd MMMM yyyy HH:mm:s.ffff gg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd MMMM yyyyy HH:mm:s.ffff gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd MMMM yyyy HH:mm:s.ffff zz gg&nbsp;&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd MMMM yyyyy HH:mm:s.ffff zz gg&#8217;)<\/p>\n<p style=\"padding-left: 120px\">&#8220;dddd dd MMMM yyyy HH:mm:s.ffff zzz gg&nbsp; :&nbsp; {0} &#8221; -f (get-date -Format &#8216;dddd dd MMMM yyyyy HH:mm:s.ffff zzz gg&#8217;)&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary: Learn how to use Windows PowerShell to format dates. &nbsp;How can I discover the formats that are available to use in Windows PowerShell when I format date and time information? &nbsp;One way is to keep this script handy and run it when you have a date formatting issue to output common formats: &#8220;d ShortDatePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [&hellip;]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[56,356,189,45],"class_list":["post-2580","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-guest-blogger","tag-powertip","tag-richard-siddaway","tag-windows-powershell"],"acf":[],"blog_post_summary":"<p>Summary: Learn how to use Windows PowerShell to format dates. &nbsp;How can I discover the formats that are available to use in Windows PowerShell when I format date and time information? &nbsp;One way is to keep this script handy and run it when you have a date formatting issue to output common formats: &#8220;d ShortDatePattern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/2580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=2580"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/2580\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=2580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=2580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=2580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}