有了當前時間,如何獲得下一周最后一天的時間?
uj5u.com熱心網友回復:
本周第一天(1)星期天為第一天
RelativeDate( today(), 2 - 1 - (1 - sign(daynumber(today()) + 1 -1))*7 -DayNumber ( today() )
(2)星期一為第一天
RelativeDate( today(), 2 - 0 - (1 - sign(daynumber(today()) + 0 -1))*7 -DayNumber ( today() )
下一周最后一天,就是本周第一天 + 13天
uj5u.com熱心網友回復:
relativedate(today(),2 + daynumber(today()))uj5u.com熱心網友回復:
relativedate(today(),15 - daynumber(today()))uj5u.com熱心網友回復:
uj5u.com熱心網友回復:
uj5u.com熱心網友回復:
uj5u.com熱心網友回復:
先計算當前時間離本周最后一天還有幾天,然后在加上7天就可以。uj5u.com熱心網友回復:
relativedate(today(),2 + daynumber(today()))轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/51106.html
標籤:腳本語言
上一篇:創建資料視窗Cannot create datawindow SQLSTATE=37000 我該怎么辦
下一篇:跪求!PB列印格式調整問題?
