2021/02/27 #勤務表を作る＃３

皆様おはようございます、

#猫でもできるPowerShell（備忘録）

#勤務表を作る＃３

$firstDay = '2021/03/01'
$openTime = '09:00'
$closeTime = '17:30'

$ad = '(Get-Date $firstDay).AddDays($_)'
$DW = $ad + '.DayOfWeek'
%{0..30} |
select `
@{la='Date_2' ; ex={'D'+ "{0:D2}" -f ($_+1)}}, #2桁のゼロ詰め
@{la='Date_3' ; ex={'D'+ "{0:D3}" -f (iex $ad).DayOfYear}}, #3桁のゼロ詰め
@{la='日付' ; ex={Get-Date (iex $ad) -F yyyy/MM/dd}},
@{la='曜日' ; ex={iex $DW}},
@{la='開始時刻'; ex={if ((iex $DW) -eq 'sunday') {}
　elseif((iex $DW) -eq 'saturday') {}
　else {$openTime}} },
@{la='終了時刻'; ex={if ((iex $DW) -eq 'sunday') {}
　elseif((iex $DW) -eq 'saturday') {}
　else {$closeTime}} },
@{la='経費' ; ex={}},
@{la='備考' ; ex={}} |
Out-GridView

f:id:TPTPTb:20210228010527p:plain