Weekly-Monthly-ReportFrequency.ps1

# Quick abstraction test
$d = (Get-Date)
$frequency = "Weekly"
$query = "exec prc_ReportXYZ {0}, {1};" 
switch ($frequency) {
    "Weekly" {
        $beginDate = $d.AddDays(-$d.DayOfWeek).ToString('MM/dd/yy')
        $endDate = (Get-Date $beginDate).AddDays(7).ToString('MM/dd/yy')
    }
    "Monthly" {
        $beginDate = $d.AddDays(1-$d.Day).ToString('MM/dd/yy')
        $endDate = (Get-Date $beginDate).AddMonths(1).ToString('MM/dd/yy')
    }
}

$beginDate
$endDate

$query = $query -f $beginDate, $endDate

$query