{"id":8261,"date":"2015-01-21T00:01:00","date_gmt":"2015-01-21T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2015\/01\/21\/adding-and-subtracting-dates-with-powershell\/"},"modified":"2019-02-18T10:35:52","modified_gmt":"2019-02-18T17:35:52","slug":"adding-and-subtracting-dates-with-powershell","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/adding-and-subtracting-dates-with-powershell\/","title":{"rendered":"Adding and Subtracting Dates with PowerShell"},"content":{"rendered":"

Summary<\/b>: Microsoft Scripting Guy, Ed Wilson, talks about adding and subtracting dates with Windows PowerShell.<\/span>\nMicrosoft Scripting Guy, Ed Wilson, is here. One of the things I really like about Windows PowerShell is the way it simplifies adding and subtracting from dates. For example, if I want to find users who haven’t logged in to the domain for 120 days, I need to be able to create a date that was 120 days ago. Then I need to get the date of their last log-in, and see if that date is more recent than 120 days ago.\nI may need to do the same thing with the last time that files were accessed or to examine the date that print jobs were submitted to a print server. I may simply want to see all events from the security log that occurred within a specific date range. I may want to see how many days until a user’s password expires so that I can warn them when the password comes within 10 days of expiring.\nWhatever the need, quite often dates come into play. When I know how to create a specific DateTime<\/b> object, whether in the past, in the future, or even for the present, I can use that DateTime<\/b> object as an input parameter for other Windows PowerShell cmdlets.\nThere are six core Windows PowerShell cmdlets that accept DateTime<\/b> objects as input parameters. These cmdlets are:<\/p>\n

PS C:> Get-Command -ParameterType [datetime] | ft -AutoSize<\/p>\n

CommandType Name         ModuleName                    <\/p>\n

———– —-                     ———-                    <\/p>\n

Cmdlet      Get-Date     Microsoft.PowerShell.Utility  <\/p>\n

Cmdlet      Get-EventLog Microsoft.PowerShell.Management<\/p>\n

Cmdlet      Get-Job      Microsoft.PowerShell.Core     <\/p>\n

Cmdlet      New-TimeSpan Microsoft.PowerShell.Utility  <\/p>\n

Cmdlet      Set-Date     Microsoft.PowerShell.Utility  <\/p>\n

Cmdlet      Test-Path    Microsoft.PowerShell.Management\nTo find which parameters accept a <\/span>DateTime<\/b> object, I can use the <\/span>Get-Help<\/b> cmdlet and look at the syntax for the various parameter sets. This technique is shown here for the <\/span>Test-Path<\/b> cmdlet:<\/span><\/p>\n

PS C:> (Get-Help test-path).syntax<\/p>\n

Test-Path [-Path] <String[]> [-Credential <PSCredential>] [-Exclude <String[]>]<\/p>\n

[-Filter <String>] [-Include <String[]>] [-IsValid] [-PathType <TestPathType>]<\/p>\n

[-UseTransaction [<SwitchParameter>]] [<CommonParameters>]<\/p>\n

Test-Path [-Credential <PSCredential>] [-Exclude <String[]>] [-Filter <String>]<\/p>\n

[-Include <String[]>] [-IsValid] [-PathType <TestPathType>] -LiteralPath<\/p>\n

<String[]> [-UseTransaction [<SwitchParameter>]] [<CommonParameters>]<\/p>\n

Test-Path [-NewerThan <DateTime>] [-OlderThan <DateTime>] [<CommonParameters>]<\/p>\n

Adding dates and times—the easy way<\/h2>\n

If I want to add hours to a DateTime<\/b> object, all I need to do is to create an instance of a DateTime<\/b> object, and call the AddHours<\/b> method. Here is an example using the Get-Date<\/b> cmdlet:<\/p>\n

PS C:> (Get-Date).AddHours(2)<\/p>\n

Friday, January 16, 2015 6:27:46 PM\nI can also use an intermediate variable to hold the DateTime<\/b> object and to call the method. This technique appears here:<\/p>\n

PS C:> $dte = Get-Date<\/p>\n

PS C:> $dte.AddHours(3)<\/p>\n

Friday, January 16, 2015 7:29:00 PM\nIt is also possible to convert a string into a DateTime<\/b> object by using the [dateTime] type accelerator. I first create a specific date and time, and then I call the AddHours<\/b> method:<\/p>\n

PS C:> $dte = Get-Date<\/p>\n

PS C:> $dte.AddHours(3)<\/p>\n

Friday, January 16, 2015 7:29:00 PM\nIf I want to add days, it is the same technique, but I call the AddDays<\/b> method instead of AddHours<\/b>. This technique is shown here by using the Get-Date<\/b> cmdlet:<\/p>\n

PS C:> Get-Date<\/p>\n

Friday, January 16, 2015 4:32:57 PM<\/p>\n

PS C:> (Get-date).AddDays(12)<\/p>\n

Wednesday, January 28, 2015 4:33:00 PM\nI can add lots of stuff to DateTime<\/b> objects. Here is a list of the various Add<\/b> methods.<\/p>\n

PS C:> Get-date | Get-Member -MemberType Method -Name a*<\/p>\n

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

Name            MemberType Definition                           <\/p>\n

—-            ———- ———-                           <\/p>\n

Add             Method     datetime Add(timespan value)         <\/p>\n

AddDays         Method     datetime AddDays(double value)       <\/p>\n

AddHours        Method     datetime AddHours(double value)      <\/p>\n

AddMilliseconds Method     datetime AddMilliseconds(double value)<\/p>\n

AddMinutes      Method     datetime AddMinutes(double value)    <\/p>\n

AddMonths       Method     datetime AddMonths(int months)       <\/p>\n

AddSeconds      Method     datetime AddSeconds(double value)    <\/p>\n

AddTicks        Method     datetime AddTicks(long value)        <\/p>\n

AddYears        Method     datetime AddYears(int value)     \nIf I want to create a DateTime<\/b> object that represents a date in the past, I still use the appropriate Add<\/b> method, but I supply a negative number. So in the following example, I create a DateTime<\/b> object that is 12 days in the past:<\/p>\n

PS C:> Get-Date<\/p>\n

Friday, January 16, 2015 4:34:53 PM<\/p>\n

PS C:> (Get-Date).adddays(-12)<\/p>\n

Sunday, January 4, 2015 4:35:12 PM\nThe technique works exactly the same way for subtracting hours. Here, I create a DateTime<\/b> object that is five hours in the past:<\/p>\n

PS C:> Get-Date<\/p>\n

Friday, January 16, 2015 4:36:24 PM<\/p>\n

PS C:> (Get-Date).AddHours(-5)<\/p>\n

Friday, January 16, 2015 11:36:46 AM\nI can even combine methods, so I do not have to add -1 day and then add -2 hours by using intermediate expressions (unless I want to). Here is an example of using intermediate expressions:<\/p>\n

$dte = Get-Date<\/p>\n

$dte = $dte.AddDays(-1)<\/p>\n

$dte = $dte.AddHours(-2)<\/p>\n

$dte\nBut I can simplify this into a single line as shown here:<\/p>\n

PS C:> ((Get-Date).AddDays(-1)).addhours(-2)<\/p>\n

Thursday, January 15, 2015 2:42:28 PM\nThe advantage of using the intermediate expressions is it is probably easier to read.<\/p>\n

Some fun with DateTime objects<\/h2>\n

Because it is so easy to use WMI to find the remaining runtime on a laptop battery, and it is so easy to add minutes, I created a simple script to let me know when my laptop will shut down. I use the Get-CimInstance<\/b> cmdlet to retrieve the Win32_Battery<\/b> WMI class. I then choose the EstimatedRunTime<\/b> property (which displays in minutes remaining on the battery), and I store the result in the $MinutesRunTime<\/b> variable.\nI then use the AddMinutes<\/b> method from the DateTime<\/b> object that I get from Get-Date<\/b>, and I display the result. Because I want to perform the date calculation before I display the string, I use the subexpression $()<\/b> to force the evaluation of the expression first. Here is the script:<\/p>\n

$MinutesRunTime = (Get-CimInstance win32_battery).EstimatedRunTime\n“The laptop will shut down at $((Get-Date).AddMinutes($MinutesRunTime))”<\/p>\n

Note <\/b> I only have an instance of Win32_Battery<\/b> if I am using a laptop or other portable device (such as a Microsoft Surface). Also, if I am plugged in and charging, it does not display accurate results.\nThat is all there is to adding and subtracting dates. Date Time Week will continue tomorrow when I will talk about more cool stuff.\nI invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.\nEd Wilson, Microsoft Scripting Guy<\/b> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy, Ed Wilson, talks about adding and subtracting dates with Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. One of the things I really like about Windows PowerShell is the way it simplifies adding and subtracting from dates. For example, if I want to find users who haven’t logged in to […]<\/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":[13,3,4,45],"class_list":["post-8261","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":"

Summary: Microsoft Scripting Guy, Ed Wilson, talks about adding and subtracting dates with Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. One of the things I really like about Windows PowerShell is the way it simplifies adding and subtracting from dates. For example, if I want to find users who haven’t logged in to […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/8261","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=8261"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/8261\/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=8261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=8261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=8261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}