uipath對日期進行操作

大寫?:?代表24小時制 HH

小寫?:?代表12小時制 hh

此刻時間?:?

Now.ToString?08/24/2021?09:57:47

--------------------------------------------分割線--------------------------------------------------------

當天日期?:?

Now.Date.ToString08/24/2021?00:00:00

Now.ToShortDateString08/24/2021

Now.ToString(“yyyyMMdd”)20210824

Now.ToString(“yyyy-MM-dd”)?2021-08-24

Now.ToString("yyyy/MM/dd")?2021/08/24

--------------------------------------------分割線--------------------------------------------------------

當天時間?:?

Now.ToShortTimeString?09:56

Now.ToString(“hh:mm:ss”)?09:58:36

--------------------------------------------分割線--------------------------------------------------------

Now.AddDays(3).ToString(“yyyyMMdd”)?3天後日期

Now.AddDays(-3).ToString(“yyyyMMdd”)?3天前日期

Now.AddMonths(3).ToString(“yyyyMMdd”)?3月後日期

Now.AddMonths(-3).ToString(“yyyyMMdd”)?3月前日期

Now.AddYears(3).ToString(“yyyyMMdd”)?3年後日期

Now.AddYears(-3).ToString(“yyyyMMdd”)?3年後日期

Now.Second.Tostring?當前秒數

--------------------------------------------分割線--------------------------------------------------------

指定日期前壹周的日期?:?

DateTime.Parse("2021-3-30").AddDays(-7)

中文輸出當前星期幾?:?

DateTime.Today.ToString("dddd",?new?System.Globalization.CultureInfo("zh-CN"))

星期幾?:?

Weekday(Now,vbMonday).ToString

Now.DayOfWeek.ToString

--------------------------------------------分割線--------------------------------------------------------

?判斷兩個日期相隔多少天?:?

?Date1='2021/01/01'

?Date2='2021/01/07'

?TimeDifference=Date.Parse(Date2)-Date.Parse(Date1)

?#?Date1和Date2是字符串，先轉成日期格式再相減，得到TimeSpan格式

?DayDiference?=?Math.Abs(TimeDiference.Days)

--------------------------------------------分割線--------------------------------------------------------

?表示當前時間增加壹天兩小時三分四秒

?Now.Add(New?TimeSpan(1,2,3,4))

--------------------------------------------分割線--------------------------------------------------------

?本周壹：Now.AddDays(1-Weekday(Now,vbMonday)).ToString(“yyyyMMdd”)

?本周二：Now.AddDays(2-Weekday(Now,vbMonday)).ToString(“yyyyMMdd”)

?本周三：Now.AddDays(3-Weekday(Now,vbMonday)).ToString(“yyyyMMdd”)

?本周四：Now.AddDays(4-Weekday(Now,vbMonday)).ToString(“yyyyMMdd”)

?本周五：Now.AddDays(5-Weekday(Now,vbMonday)).ToString(“yyyyMMdd”)

?下周壹：Now.AddDays(8-Weekday(Now,vbMonday)).ToString(“yyyyMMdd”)

--------------------------------------------分割線--------------------------------------------------------

當前月最後壹天?:?

DateTime.Parse(

Now.Year.ToString+"-"+Now.AddMonths(1).ToString("MM")+"-01"

).AddDays(-1).ToString("yyyy-MM-dd")

當前月第壹天?:?

Now.ToString("yyyy-MM-01")

--------------------------------------------分割線--------------------------------------------------------