首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Powershell -从周和工作日开始获取日期

问Powershell -从周和工作日开始获取日期
EN

Stack Overflow用户
提问于 2022-02-03 13:28:51
回答 1查看 409关注 0票数 2

我有一个包含“年”、“周号”和“工作日”的文件(例如“2022”、“42”、“4”、“4”代表2022年的第42周,而4代表周二。A 7代表周日。

第一周被认为是直到周日的第一天,不管是7天还是7天。上周同样的原则。这一周也可以不超过7天。

我怎么能把这个翻译成'yyyyMMdd‘这样的约会呢?

谢谢

EN

回答 1

Stack Overflow用户

发布于 2022-02-03 16:21:46

注意:

下面使用.NET的6.枚举来标识平日,这意味着星期日是0,星期一是1,.星期六是0

如果您的工作日编号方案不同(听起来是这样),则必须将其映射到上面的.。

代码语言:javascript
复制
# Convert the strings (representing CSV input) to numbers.
[int] $year, [int] $week, [int] $weekday =  '2022', '42', '4'

# The day of the week you consider the start of a calendar week.
$startOfWeekDay = [DayOfWeek]::Monday

# Calculate the start of calendar week 1 for the given year:
# The Monday on or preceding Jan 1
# Note: This date may therefore fall into the previous year.
$Jan1 = [datetime]::new($year, 1, 1)
$StartOfWeek1 = $Jan1.AddDays(-((7 + $Jan1.DayOfWeek-$startOfWeekDay) % 7))

# Calculate the start of the target calendar week.
$StartOfTargetWeek = $StartOfWeek1.AddDays($week * 7)

# Calculate the target date by determining the desired weekday
# inside the target week.
$TargetDate = $StartOfTargetWeek.AddDays((7 + $weekday-$startOfWeekDay) % 7)
$TargetDateString = $TargetDate.ToString('yyyyMMdd')

# Output *for display* both the intermediate results and the final one.
[pscustomobject] @{
  Jan1 = ($Jan1 | Out-String).Trim()
  StartOfWeek1 = ($StartOfWeek1 | Out-String).Trim()
  StartOfTargetWeek = ($StartOfTargetWeek | Out-String).Trim()
  TargetWeekDay = [DayOfWeek] $weekday
  TargetDate = ($TargetDate | Out-String).Trim()
  TargetDateString = $TargetDateString
} | Format-List

输出:

代码语言:javascript
复制
Jan1              : Saturday, January 1, 2022 12:00:00 AM
StartOfWeek1      : Monday, December 27, 2021 12:00:00 AM
StartOfTargetWeek : Monday, October 17, 2022 12:00:00 AM
TargetWeekDay     : Thursday
TargetDate        : Thursday, October 20, 2022 12:00:00 AM
TargetDateString  : 20221020
票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/70972146

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档