datepowershellpowershell-3.0

Powershell - Find the next Friday


Hoping this won't be too difficult but I am writing a script that queries user information from the domain and exports to CSV.

The script is run by our administrative staff and all they need to input into the script is the username.

The tricky part is that I need the CSV to be named based on the coming Friday.

Note: I am in Australia so my date format is DD-MM-YYYY

The way I am currently looking at going about it is as below:

# Grab the Script Run Timestamp
$ScriptRuntime = Get-Date -Day 4 -Month 5 -Year 2013

# Grab the next Friday (including today)
$NextFriday = $ScriptRuntime.AddDays(0 + $(0,1,2,3,4,5,6 -eq 5 - [int]$ScriptRuntime.dayofweek))

Write-Host "Script Run:  "$ScriptRuntime
Write-Host "Next Friday: "$NextFriday

This works OK with all days except Saturday.

What am i doing wrong?


Solution

  • I'm not sure I'm following you but here's I would get next Friday:

    $date = Get-Date
    
    for($i=1; $i -le 7; $i++)
    {        
        if($date.AddDays($i).DayOfWeek -eq 'Friday')
        {
            $date.AddDays($i)
            break
        }
    }