{"id":17551,"date":"2010-08-03T00:01:00","date_gmt":"2010-08-03T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/08\/03\/how-to-express-dates-in-different-fashions-with-windows-powershell\/"},"modified":"2010-08-03T00:01:00","modified_gmt":"2010-08-03T00:01:00","slug":"how-to-express-dates-in-different-fashions-with-windows-powershell","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-to-express-dates-in-different-fashions-with-windows-powershell\/","title":{"rendered":"How to Express Dates in Different Fashions with Windows PowerShell"},"content":{"rendered":"

 \n\"Hey,\n Hey, Scripting Guy! I need to use Windows PowerShell<\/a> to be able to parse dates. We have dates that are displayed in different ways. Some are day\/month\/year, others are month\/day\/year, and still others are year\/month\/day. I need to be able to express these different date configurations with a minimal amount of monkeying around. Is this doable using Windows PowerShell?\n— AH\n\"Hey,\n Hello AH,\nMicrosoft Scripting Guy Ed Wilson here. My significant other was all excited about listening to the PowerScripting Podcast<\/a> the other night, not because I was on it, but because one of our good friends from Sapien<\/a> Software was on it. We have known Alex Riedel since I wrote my first scripting book for Microsoft Press. He is a really cool and intelligent person. I met him in real life for the first time last year at Tech·Ed 2009 in LA (back before I had my ear problems). The following photo shows me and some imaginary friends hanging out at Tech·Ed 2009.\n<\/a>\nAH, you do not really need to parse dates in order to display the date information in a particular manner. I have seen scripts where people stored the datetime<\/b> object that was returned by the Get-Date<\/b> cmdlet, and then they retrieved the day, month, and year properties from the object and stored those values in variables. After they had that, they manually built up the date as shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>$date<\/font> <\/font>=<\/font> <\/font>Get-Date<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>$d<\/font> <\/font>=<\/font> <\/font>$date<\/font>.day<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>$m<\/font> <\/font>=<\/font> <\/font>$date<\/font>.month<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>$y<\/font> <\/font>=<\/font> <\/font>$date<\/font>.year<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> “$d\/$m\/$y”
<\/font>29<\/font>\/<\/font>7<\/font>\/<\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> “$m\/$d\/$y”
<\/font>7<\/font>\/<\/font>29<\/font>\/<\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> “$y\/$m\/$d”
<\/font>2010<\/font>\/<\/font>7<\/font>\/<\/font>29<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nWhile there is nothing wrong with such an approach, it is a lot of extra work that does not really add any value to the script at all. A better approach is to use one of the formatting specifiers. The Get-Date<\/b> cmdlet will accept two types of format specifiers<\/a>. One is the .NET format strings<\/a> and the other is UNIX formatting strings. The UNIX formatting strings are perhaps the easiest to understand, at least for basic functionality. To get the day you use %d. For the month you use %m, and for the two-digit year, you use %y. This is shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d<\/font>
<\/font>29<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%m<\/font>
<\/font>07<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%y<\/font>
<\/font>10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nYou can combine the UNIX formatting strings simply by appending one to the other. This is shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d%m%y<\/font>
<\/font>290710<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nIf you need a separator between the day\/month\/year, you simply add it at the appropriate location. You are not limited to a forward slash or a dash; you can use many different separators including the dollar sign, which elsewhere is a special character in Windows PowerShell. This is shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d\/%m\/%y<\/font>
<\/font>29<\/font>\/<\/font>07<\/font>\/<\/font>10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d-%m-%y<\/font>
<\/font>29-07-10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d.%m.%y<\/font>
<\/font>29<\/font>.<\/font>07<\/font>.<\/font>10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d*%m*%y<\/font>
<\/font>29<\/font>*<\/font>07<\/font>*<\/font>10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%d$%m$%y<\/font>
<\/font>29$07$10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nAt times, if you want the date in the standard mm\/dd\/yy format that is often used in the United States, you have two options. You can build it up using %m\/%d\/%y, or you can use the special %D format string. These two options are illustrated here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%m\/%d\/%y<\/font>
<\/font>07<\/font>\/<\/font>29<\/font>\/<\/font>10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%D<\/font>
<\/font>07<\/font>\/<\/font>29<\/font>\/<\/font>10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nIf you would like the date display to change based upon the culture input of the computer, you can use %x.\nIf you want the day, month, four-digit year, and the time, use the %c<\/b> option:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%c<\/font>
<\/font>Thu<\/font> <\/font>Jul<\/font> <\/font>29<\/font> <\/font>17<\/font>:<\/font>04<\/font>:<\/font>10<\/font> <\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nUp to this point, all our format strings have been placed after the –UFormat<\/b> parameter without any quotation marks required. This is because the parameter expects a string to be supplied as a value, and therefore it treats it accordingly. However, if you want to display the full month name, the day of the week, and four-digit year, which would require some spaces, the following syntax generates an error:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> <\/font>%B<\/font> <\/font>%d,<\/font> <\/font>%Y<\/font>
<\/font>Get-Date<\/font> <\/font>:<\/font> <\/font>Cannot<\/font> <\/font>convert<\/font> ‘System.Object[]’ <\/font>to<\/font> <\/font>the<\/font> <\/font>type<\/font> ‘System.DateTime’ <\/font>required<\/font> <\/font>by<\/font> <\/font>parameter<\/font> ‘Da
te’<\/font>.<\/font> <\/font>Specified<\/font> <\/font>method<\/font> <\/font>is<\/font> <\/font>not<\/font> <\/font>supported.<\/font>
<\/font>At<\/font> <\/font>line:<\/font>1<\/font> <\/font>char:<\/font>9<\/font>
<\/font>+<\/font> <\/font>Get-Date<\/font> <\/font><<<<<\/font> <\/font>-UFormat<\/font> <\/font>%B<\/font> <\/font>%d,<\/font> <\/font>%Y<\/font>
<\/font>+<\/font> <\/font>CategoryInfo<\/font> <\/font>:<\/font> <\/font>InvalidArgument:<\/font> <\/font>(:)<\/font> <\/font>[<\/font>Get-Date<\/font>],<\/font> <\/font>ParameterBindingException<\/font>
<\/font>+<\/font> <\/font>FullyQualifiedErrorId<\/font> <\/font>:<\/font> <\/font>CannotConvertArgument,Microsoft.PowerShell.Commands.GetDateCommand<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nThe solution is to place the string to be supplied to the –UFormat<\/b> parameter inside quotation marks. This is shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-UFormat<\/font> “%B %d, %Y”
<\/font>July<\/font> <\/font>29<\/font>,<\/font> <\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nThe syntax for the UNIX format strings for dates is documented in the online help. Use Get-Help Get-Date –Full<\/b> to see the documentation. The other way of formatting the date is to use the .NET Framework DateTime format strings<\/a>. There are two kinds of DateTime<\/b> format strings available via the .NET Framework. The first kind is the standard DateTime format strings<\/a>, and the second kind is the Custom DateTime format strings<\/a>. For example, if you need to display a short date pattern, you use the lowercase d in the cultural specific form of mm\/dd\/yy. This is shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>d<\/font>
<\/font>7<\/font>\/<\/font>29<\/font>\/<\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nBy using the standard DateTime<\/b> format strings, you can produce the long date pattern (D), the full date with a short time pattern (f), or even a full date with a long time pattern (F). These patterns are shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>D<\/font>
<\/font>Friday,<\/font> <\/font>July<\/font> <\/font>30<\/font>,<\/font> <\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>f<\/font>
<\/font>Friday,<\/font> <\/font>July<\/font> <\/font>30<\/font>,<\/font> <\/font>2010<\/font> <\/font>11<\/font>:<\/font>32<\/font> <\/font>AM<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>F<\/font>
<\/font>Friday,<\/font> <\/font>July<\/font> <\/font>30<\/font>,<\/font> <\/font>2010<\/font> <\/font>11<\/font>:<\/font>32<\/font>:<\/font>18<\/font> <\/font>AM<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nYou can create sortable date\/time patterns that conform to ISO 8601 (s) or a universal sortable date\/time pattern with no time zone conversion (u) or a universal sortable date\/time pattern that displays universal time (U). These are shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>s<\/font>
<\/font>2010-07-30T11:<\/font>36<\/font>:<\/font>23<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>u<\/font>
<\/font>2010-07-30<\/font> <\/font>11<\/font>:<\/font>36<\/font>:26Z<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>U<\/font>
<\/font>Friday,<\/font> <\/font>July<\/font> <\/font>30<\/font>,<\/font> <\/font>2010<\/font> <\/font>3<\/font>:<\/font>36<\/font>:<\/font>31<\/font> <\/font>PM<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nIf you need to define a custom date you use a combination of d, M and y. Note that the capital Y is not used. This can actually be a bit confusing if you are using the pattern ddMMMY. One other thing to keep in mind is that lowercase m is used with minutes, and capital M is used for months. If you are not careful, this can create a difficult troubleshooting scenario especially if you are writing code before 12 minutes after the hour. Examples of using these are shown here:\nPS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>d<\/font>
<\/font>7<\/font>\/<\/font>30<\/font>\/<\/font>2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>dd<\/font>
<\/font>30<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddM<\/font>
<\/font>307<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMM<\/font>
<\/font>3007<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMM<\/font>
<\/font>30Jul<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMMY<\/font>
<\/font>30JulY<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMMYY<\/font>
<\/font>30JulYY<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMMy<\/font>
<\/font>30Jul10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMMyy<\/font>
<\/font>30Jul10<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMMyyy<\/font>
<\/font>30Jul2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font> <\/font>Get-Date<\/font> <\/font>-Format<\/font> <\/font>ddMMMyyyy<\/font>
<\/font>30Jul2010<\/font>
<\/font>PS<\/font> <\/font>C:><\/font>\nAH, that is all there is to using Windows PowerShell to perform date manipulation. Date Week will continue tomorrow as we discuss subtracting dates.\nWe invite you to follow us on Twitter<\/a> or Facebook<\/a>. If you have any questions, send email to us at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.\n <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

  Hey, Scripting Guy! I need to use Windows PowerShell to be able to parse dates. We have dates that are displayed in different ways. Some are day\/month\/year, others are month\/day\/year, and still others are year\/month\/day. I need to be able to express these different date configurations with a minimal amount of monkeying around. Is […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[13,3,4,45],"class_list":["post-17551","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-dates-and-times","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

  Hey, Scripting Guy! I need to use Windows PowerShell to be able to parse dates. We have dates that are displayed in different ways. Some are day\/month\/year, others are month\/day\/year, and still others are year\/month\/day. I need to be able to express these different date configurations with a minimal amount of monkeying around. Is […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17551","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\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=17551"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17551\/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=17551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=17551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=17551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}