Advertisement
crexin

Get-WeekNumberofCurrentQuarter

Dec 6th, 2015
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Get current week in a quarter
  2.  
  3. function Get-ExtendedDate
  4.  
  5. {
  6.  
  7.  $a = get-date
  8.  
  9.   add-member -MemberType scriptmethod -name GetWeekOfYear -value {get-date -uformat %V} -inputobject $a
  10.  
  11.  $a
  12.  
  13.  } #end function Get-ExtendedDate
  14.  
  15.  #Current Quarter
  16.  $CurrentQuarter = [Math]::ceiling((Get-date -f MM)/3)
  17.  
  18.  #
  19.  If ($CurrentQuarter -eq 1) {
  20.     $WeekNoOfCurrentQuarter = (Get-ExtendedDate).getWeekOfYear()
  21. } else {
  22.     $WeekNoOfCurrentQuarter = (Get-ExtendedDate).getWeekOfYear() - ($CurrentQuarter-1)*13
  23.    
  24. }
  25. Write-Output $WeekNoOfCurrentQuarter
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement