{"id":17571,"date":"2010-08-02T00:01:00","date_gmt":"2010-08-02T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/08\/02\/using-windows-powershell-to-work-with-dates\/"},"modified":"2010-08-02T00:01:00","modified_gmt":"2010-08-02T00:01:00","slug":"using-windows-powershell-to-work-with-dates","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/using-windows-powershell-to-work-with-dates\/","title":{"rendered":"Using Windows PowerShell to Work with Dates"},"content":{"rendered":"

 \n\"Hey,\nHey, Scripting Guy! I need to be able to use Windows PowerShell<\/a> to work with dates. Dates have always been a difficult thing to work with, and I just dread scripting anything that has to do with dates. It seemed that VBScript had a dozen functions that were used to work with dates and times. Is there something similar for Windows PowerShell?\n— GS\n \n\"Hey,\nHello GS,\nMicrosoft Scripting Guy Ed Wilson here. I have never had too much problems with dates. Basically, I just pop them in my mouth whole like candy. The best dates I ever had were in Egypt. Oh, wait a minute, you don’t mean those kinds of dates. Sorry. In the old days, databases<\/a> used to have three fields for the date. One for day, one for month and one for year. You may have heard about the Y2K bug<\/a>? That was because the field for year was only big enough for the last two numbers of the year … and therefore the year 2000 would be represented as 00. This is a serious problem if you are dealing with medical records and the person is born in 5\/4\/00. You do not know whether to send the person to geriatrics or to pediatrics.\nWhen working on one of those old systems, you had to build up the date by reading three different fields. If I were going to do a similar thing in Windows PowerShell, it might look like this:\nPS<\/span> <\/span>C:><\/span> <\/span>$dd<\/span> <\/span>=<\/span> “05”
<\/span>PS<\/span> <\/span>C:><\/span> <\/span>$mm<\/span> <\/span>=<\/span> “09”
<\/span>PS<\/span> <\/span>C:><\/span> <\/span>$yy<\/span> <\/span>=<\/span> “10”
<\/span>PS<\/span> <\/span>C:><\/span> “$dd\/$mm\/$yy”
<\/span>05<\/span>\/<\/span>09<\/span>\/<\/span>10<\/span>
<\/span>PS<\/span> <\/span>C:><\/span>\nOne of the great things about Windows PowerShell is that it is object oriented. Everything in Windows PowerShell is an object, even the string I just built up…whoops, I spoiled the surprise. Let’s pretend I did not spoil the surprise (I like spoiling my supper too by eating desert first, but that is a different story—although it could have something to do with dates). The following code is really ugly, but it works because of the “object-ness” of Windows PowerShell. To find out what kind of object you are working with, you can use the GetType<\/b> method as shown here:\n <\/p>\n

PS C:> “$dd\/$mm\/$yy”.GetType()<\/p>\n

IsPublic IsSerial Name                                     <\/span>BaseType
——– ——– —-                                     <\/span>——–
True     <\/span>True     <\/span>String                                   <\/span>System.Object<\/p>\n

PS C:><\/p>\n

<\/span><\/span><\/span><\/p>\n

<\/span>\nI said the previous code was ugly, but that is only because it looks strange. In general, I would use a set of parentheses before calling a method like GetType<\/b>:\n <\/p>\n

PS C:> (“$dd\/$mm\/$yy”).GetType()<\/p>\n

IsPublic IsSerial Name                                     <\/span>BaseType
——– ——– —-                          <\/span>           <\/span>——–
True     <\/span>True     <\/span>String                                   <\/span>System.Object<\/p>\n

PS C:><\/p>\n

<\/span><\/span><\/span><\/p>\n

<\/span>\nActually using the parentheses is a good idea, because at times you can get yourself into trouble. This is shown here, where I attempt to get the type of the number 1:\nPS<\/span> <\/span>C:><\/span> <\/span>1<\/span>.GetType()<\/span>
<\/span>Bad<\/span> <\/span>numeric<\/span> <\/span>constant:<\/span> <\/span>1<\/span>..<\/span>
<\/span>At<\/span> <\/span>line:<\/span>1<\/span> <\/span>char:<\/span>3<\/span>
<\/span>+<\/span> <\/span>1<\/span>.<\/span> <\/span><<<<<\/span> <\/span>GetType()<\/span>
<\/span>+<\/span> <\/span>CategoryInfo<\/span> <\/span>:<\/span> <\/span>ParserError:<\/span> <\/span>(<\/span>1<\/span>.:String)<\/span> <\/span>[],<\/span> <\/span>ParentContainsErrorRecordException<\/span>
<\/span>+<\/span> <\/span>FullyQualifiedErrorId<\/span> <\/span>:<\/span> <\/span>BadNumericConstant<\/span>
<\/span>PS<\/span> <\/span>C:><\/span>\nThe problem is not because the number is not an object and does not have a type. The problem is that Windows PowerShell is not sure what to do. The parentheses help in that regard. Just as in high school algebra, the parentheses tells Windows PowerShell to perform the operation inside before looking outside the parentheses. As shown here, the number 1 is in fact an object:\n <\/p>\n

PS C:> (1).GetType()<\/p>\n

IsPublic IsSerial Name                                     <\/span>BaseType
——– ——– —-                             <\/span>        <\/span>——–
True     <\/span>True     <\/span>Int32                                    <\/span>System.ValueType<\/p>\n

PS C:><\/p>\n

<\/span><\/span><\/span><\/p>\n

<\/span>\nWindows PowerShell treats the number 1 as an int32. It is actually smaller than that, and you can specifically cast it to an int16. This is shown here:\n <\/p>\n

PS C:> [int16]1 | gm<\/p>\n

   <\/span>TypeName: System.Int16<\/p>\n

Name        <\/span>MemberType Definition
—-        <\/span>———- ———-
CompareTo   <\/span>Method     <\/span>int CompareTo(System.Object value), int CompareTo(System.Int16 value)
Equals      <\/span>Method     <\/span>bool Equals(System.Int16 obj), bool Equals(System.Object obj)
GetHashCode Method     <\/span>int GetHashCode()
GetType     <\/span>Method     <\/span>type GetType()
GetTypeCode Method     <\/span>System.TypeCode GetTypeCode()
ToString    <\/span>Method     <\/span>string ToString(System.IFormatProvider provider), string ToString(string …<\/p>\n

<\/span><\/span><\/span><\/p>\n

<\/span>\nCasting? What is that? Windows PowerShell has a dynamic type system, and I can convert one data type to another data type on the fly. By default, Windows PowerShell treats all numbers as int32. As seen earlier, I can constrain the type, force the type, or cast the type (whatever jargon you wish to use) to make my int32 into an int16. Cool? Ok, perhaps it depends on your geek factor. Let’s get back to the problem at hand: dates. We have just seen that we had a string when we put the numbers together. Remember this?\n <\/p>\n

PS C:> “$dd\/$mm\/$yy”
05\/09\/10
PS C:> “$dd\/$mm\/$yy”.GetType()<\/p>\n

IsPublic IsSerial Name                                     <\/span>BaseType
——– ——– —-                                     <\/span>——–
True     <\/span>True     <\/span>String         <\/span>                          <\/span>System.Object<\/p>\n

PS C:><\/p>\n

<\/span><\/span><\/span><\/p>\n

<\/span>\nOne of the really cool things about objects is they have methods and properties. The problem is that our date is a string. Dates are awesome in cakes and in cookies<\/a>, but not if they are strings. The members of a system.string<\/b> class are suboptimal for dealing with dates. This is shown in the following image.\n\"Image\nWhile it is true that I could do string manipulation to parse the date, it would be better if we had a datetime<\/b> object to work with. To do this, we can cast the string to a system.datetime<\/a> .NET Framework object. We can then use the GetType<\/a> method to ensure the conversion has taken place; although this last step is basically redundant because the results of the cast are immediately observable. Remember me saying that using the “ugly code” could get you into trouble? This is shown here, where an error is thrown. The fix is to use the parentheses:\n <\/p>\n

PS C:> [datetime]”$dd\/$mm\/$yy”<\/p>\n

Sunday, May 09, 2010 12:00:00 AM<\/p>\n

PS C:> [datetime]”$dd\/$mm\/$yy”.GetType()
Cannot convert the “System.String” value of type “System.RuntimeType” to type “System.DateTime”.
At line:1 char:32
+ [datetime]”$dd\/$mm\/$yy”.GetType <<<< ()
    <\/span>+ CategoryInfo          <\/span>: NotSpecified: (:) [], RuntimeException
    <\/span>+ FullyQualifiedErrorId : RuntimeException<\/p>\n

PS C:> ([datetime]”$dd\/$mm\/$yy”).GetType()<\/p>\n

IsPublic IsSerial Name                                     <\/span>BaseType
——– ——– —-                                     <\/span>——–
True     <\/span>True     <\/span>DateTime                                 <\/span>System.ValueType<\/p>\n

PS C:><\/p>\n

<\/span><\/span><\/span><\/p>\n

<\/span>\nIn addition to gaining a nicer display of the date, the conversion from string to date has provided a number of useful members. Using the Get-Member<\/b> cmdlet displays the methods and properties that are supplied by the system.datetime<\/b> .NET Framework class:\n <\/p>\n

PS C:> [datetime]”$dd\/$mm\/$yy” | Get-Member<\/p>\n

   <\/span>TypeName: System.DateTime<\/p>\n

Name                 <\/span>MemberType     <\/span>Definition
—-                 <\/span>———-     <\/span>———-
Add                  <\/span>Method         <\/span>System.DateTime Add(System.TimeSpan value)
AddDays              <\/span>Method         <\/span>System.DateTime AddDays(double value)
AddHours             <\/span>Method         <\/span>System.DateTime AddHours(double value)
AddMilliseconds      <\/span>Method         <\/span>System.DateTime AddMilliseconds(double value)
AddMinutes    <\/span>       <\/span>Method         <\/span>System.DateTime AddMinutes(double value)
AddMonths            <\/span>Method         <\/span>System.DateTime AddMonths(int months)
AddSeconds           <\/span>Method         <\/span>System.DateTime AddSeconds(double value)
AddTicks             <\/span>Method         <\/span>System.DateTime AddTicks(long value)
AddYears             <\/span>Method         <\/span>System.DateTime AddYears(int value)
CompareTo            <\/span>Method         <\/span>int CompareTo(System.Object value), int CompareTo(System.Dat…
Equals               <\/span>Method         <\/span>bool Equals(System.Object value), bool Equals(System.DateTim…
GetDateTimeFormats   <\/span>Method         <\/span>string[] GetDateTimeFormats(), string[] GetDateTimeFormats(S…
GetHashCode          <\/span>Method         <\/span>int GetHashCode()
GetType              <\/span>Method         <\/span>type GetType()
GetTypeCode          <\/span>Method         <\/span>System.TypeCode GetTypeCode()
IsDaylightSavingTime Method         <\/span>bool IsDaylightSavingTime()
Subtract             <\/span>Method         <\/span>System.TimeSpan Subtract(System.DateTime value), System.Date…
ToBinary             <\/span>Method   <\/span>      <\/span>long ToBinary()
ToFileTime           <\/span>Method         <\/span>long ToFileTime()
ToFileTimeUtc        <\/span>Method         <\/span>long ToFileTimeUtc()
ToLocalTime          <\/span>Method         <\/span>System.DateTime ToLocalTime()
ToLongDateString     <\/span>Method         <\/span>string ToLongDateString()
ToLongTimeString     <\/span>Method         <\/span>string ToLongTimeString()
ToOADate             <\/span>Method         <\/span>double ToOADate()
ToShortDateString    <\/span>Method         <\/span>string ToShortDateString()
ToShortTimeString    <\/span>Method         <\/span>string ToShortTimeString()
ToString             <\/span>Method         <\/span>string ToString(), string ToString(string format), string To…
ToUniversalTime      <\/span>Method         <\/span>System.DateTime ToUniversalTime()
Date                 <\/span>Property       <\/span>System.DateTime Date {get;}
Day                  <\/span>Property  <\/span>     <\/span>System.Int32 Day {get;}
DayOfWeek         &\nnbsp;  <\/span>Property       <\/span>System.DayOfWeek DayOfWeek {get;}
DayOfYear            <\/span>Property       <\/span>System.Int32 DayOfYear {get;}
Hour                 <\/span>Property       <\/span>System.Int32 Hour {get;}
Kind                 <\/span>Property       <\/span>System.DateTimeKind Kind {get;}
Millisecond          <\/span>Property       <\/span>System.Int32 Millisecond {get;}
Minute               <\/span>Property       <\/span>System.Int32 Minute {get;}
Month                <\/span>Property       <\/span>System.Int32 Month {get;}
Second               <\/span>Property       <\/span>System.Int32 Second {get;}
Ticks                <\/span>Property       <\/span>System.Int64 Ticks {get;}
TimeOfDay            <\/span>Property       <\/span>System.TimeSpan TimeOfDay {get;}
Year                 <\/span>Property       <\/span>System.Int32 Year {get;}
DateTime             <\/span>ScriptProperty System.Object DateTime {get=if ((& { Set-StrictMode -Version…<\/p>\n

PS C:><\/p>\n

<\/span><\/span><\/span><\/p>\n

 <\/p>\n

GS, it is obvious that you are not the only one who thought working with dates was annoying. The large collection of methods and properties exposed by the datetime<\/b> class can help to smooth out the difficulty of working with dates. The benefits are immediately available, and most are extremely easy to use. For example, what was the day of the week for our date that we created?<\/span><\/span>\nPS<\/span> <\/span>C:><\/span> <\/span>([datetime]<\/span>“$dd\/$mm\/$yy”<\/span>).dayOfWeek<\/span>
<\/span>Sunday<\/span>
<\/span>PS<\/span> <\/span>C:><\/span>\nWhat was the day of the year? <\/p>\n

PS<\/span> <\/span>C:><\/span> <\/span>([datetime]<\/span>“$dd\/$mm\/$yy”<\/span>).dayOfyear<\/span>
<\/span>129<\/span>
<\/span>PS<\/span> <\/span>C:><\/span> <\/div>\n

What about if I need to add 45 days to my original date? It is no problem using the addDays<\/b> method:<\/p>\n

PS<\/span> <\/span>C:><\/span> <\/span>([datetime]<\/span>“$dd\/$mm\/$yy”<\/span>).addDays(<\/span>45<\/span>)<\/span>
<\/span>Wednesday,<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

  Hey, Scripting Guy! I need to be able to use Windows PowerShell to work with dates. Dates have always been a difficult thing to work with, and I just dread scripting anything that has to do with dates. It seemed that VBScript had a dozen functions that were used to work with dates and […]<\/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-17571","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 be able to use Windows PowerShell to work with dates. Dates have always been a difficult thing to work with, and I just dread scripting anything that has to do with dates. It seemed that VBScript had a dozen functions that were used to work with dates and […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17571","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=17571"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/17571\/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=17571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=17571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=17571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}