{"id":628,"date":"2008-09-04T08:45:32","date_gmt":"2008-09-04T16:45:32","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2008\/09\/04\/get-otherdate\/"},"modified":"2008-09-04T08:45:32","modified_gmt":"2008-09-04T16:45:32","slug":"get-otherdate","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2008\/09\/04\/get-otherdate\/","title":{"rendered":"Get-OtherDate"},"content":{"rendered":"

PowerShell’s [DATETIME] object has some handy methods for calculating a date such as AddDays<\/strong>().<\/p>\n\n\n\n
\n
PS C:\\> get-date\n\nWednesday, September 03, 2008 4:11:18 PM\n\nPS C:\\> (get-date).AddDays(23)\n\nFriday, September 26, 2008 4:11:34 PM\n\nPS C:\\><\/font><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
You can even subtract by adding a negative number:<\/p>\n\n\n\n
\n
PS C:\\> (get-date).AddHours(-67)\n\nSunday, August 31, 2008 9:14:40 PM<\/font>\n<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
The [DATETIME] object also allows you to add a TimeSpan like this:<\/p>\n\n\n\n
\n
PS C:\\> [datetime]$d=\"2\/22\/2008 5:00AM\"\nPS C:\\> #Add 2 days
PS C:\\> $d.Add(\"2:0:0\")\n\nFriday, February 22, 2008 7:00:00 AM\nPS C:\\> #Add 34 minutes\nPS C:\\> $d.Add(\"0:34:0\")\n\nFriday, February 22, 2008 5:34:00 AM\n\nPS C:\\> #Add 15 seconds\nPS C:\\> $d.Add(\"0:0:15\")\n\nFriday, February 22, 2008 5:00:15 AM\n\nPS C:\\> #Add 2 days, 3 hours and 15 min
PS C:\\> $d.Add(\"2:3:15\")\n\nFriday, February 22, 2008 7:03:15 AM<\/font><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
This is all nice. But what if you wanted to calculate a more complex date time, perhaps one in years? There is an AddYears()<\/strong> method. Although none of this will help if you want to calculate a date that is 1 year, 2 months  and 1 day from now. For those situations, or if you want a simpler approach instead of calling methods, I wrote the Get-OtherDate<\/font><\/strong> function.<\/p>\n
\n
\n
   1:<\/span> Function Get-OtherDate {<\/pre>\n
   2:<\/span>     Param([datetime]$date=(Get-Date),<\/pre>\n
   3:<\/span>           [int32]$years=0,<\/pre>\n
   4:<\/span>           [int32]$months=0,<\/pre>\n
   5:<\/span>           [int32]$days=0,<\/pre>\n
   6:<\/span>           [int32]$hours=0,<\/pre>\n
   7:<\/span>           [int32]$minutes=0,<\/pre>\n
   8:<\/span>           [int32]$seconds=0,<\/pre>\n
   9:<\/span>           [int32]$milliseconds=0<\/pre>\n
  10:<\/span>           )<\/pre>\n
  11:<\/span>           <\/pre>\n
  12:<\/span>     [datetime]$dt=$date   <\/pre>\n
  13:<\/span>     if<\/span> ($milliseconds -ne<\/span> 0) {$dt=$dt.AddMilliseconds($milliseconds)}<\/pre>\n
  14:<\/span>     if<\/span> ($seconds -ne<\/span> 0) {$dt=$dt.AddSeconds($seconds)}<\/pre>\n
  15:<\/span>     if<\/span> ($minutes -ne<\/span> 0) {$dt=$dt.AddMinutes($minutes)}<\/pre>\n
  16:<\/span>     if<\/span> ($hours -ne<\/span> 0) {$dt=$dt.AddHours($hours)}<\/pre>\n
  17:<\/span>     if<\/span> ($days -ne<\/span> 0) {$dt=$dt.AddDays($days)}     <\/pre>\n
  18:<\/span>     if<\/span> ($months -ne<\/span> 0) {$dt=$dt.AddMonths($months)}<\/pre>\n
  19:<\/span>     if<\/span> ($years -ne<\/span> 0) {$dt=$dt.AddYears($years)}<\/pre>\n
  20:<\/span>  <\/pre>\n
  21:<\/span>     write $dt          <\/pre>\n
  22:<\/span>   <\/pre>\n
  23:<\/span> }<\/pre>\n<\/div>\n<\/div>\n
The function takes as parameters a starting date ($date) and then one or more parameters for time intervals such as -days, -hours or -minutes.  You don’t have to specify a starting date, it will default to the current date and time.  All the function does is call the appropriate [datetime] method and builds a new date time object moving  from the smallest time interval to the largest. Here are some examples of the function in use with the default current date:<\/p>\n\n\n\n
\n
PS C:\\> get-date\n\nThursday, September 04, 2008 12:15:43 PM\n\nPS C:\\> Get-OtherDate -months 1 -days 11 -hours 7\n\nWednesday, October 15, 2008 7:15:46 PM\n\nPS C:\\> Get-OtherDate -days -45\n\nMonday, July 21, 2008 12:16:08 PM<\/font><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Here are some samples using a different date:<\/p>\n\n\n\n
\n
PS C:\\> get-OtherDate 7\/4\/2008 -days 99\n\nSaturday, October 11, 2008 12:00:00 AM\n\nPS C:\\> Get-OtherDate 12:34 -hours 4\n\nThursday, September 04, 2008 4:34:00 PM\n\nPS C:\\> Get-OtherDate 22:34 -hours -4 -minutes -14\n\nThursday, September 04, 2008 6:20:00 PM<\/font><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
There’s nothing really special here.  All I’ve done is create a shortcut function. An advantage is that I can create an alias (like od) and take advantage of short parameter names. Here’s how this might work in a production environment:<\/p>\n\n\n\n
\n
PS C:\\> [ADSI]$admin=\"WinNT:\/\/$env:computername\/Administrator,user\"\nPS C:\\> $lastset = od -s (-$admin.passwordage.value)\nPS C:\\> $expires = od $lastset -day 60\nPS C:\\> Write-host \"Password last set $lastSet and expires $expires\"\nPassword last set 09\/02\/2008 22:29:51 and expires 11\/01\/2008 22:29:51\nPS C:\\><\/font><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
Download the script file here<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
PowerShell’s [DATETIME] object has some handy methods for calculating a date such as AddDays(). Let me show you how as well as my own function for those situations where PowerShell’s methods just aren’t enough.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[65,281,282,28,57],"class_list":["post-628","post","type-post","status-publish","format-standard","hentry","category-windows-powershell","tag-automation","tag-datetime","tag-functions","tag-powershell","tag-scripting"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=628"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/628\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}