ADDTODATE(text/date,unit,delta)
Returns the date after adding a specified number of years, months, days, hours, minutes, or seconds to the provided date.
text/date
Represents the date to which the time delta will be added.
Unit
"Y/y": in years
"D/d": in days
"M/m": in months
"H/h": in hours
"MI/mi": in minutes
"S/s": in seconds
The unit is required to be a constant. Field references are not supported, but direct parameter input is allowed.
Delta
Value
If any parameter is NULL, the result is NULL.
ADDTODATE("2023-01-01", "y", 1)
2024-01-01
DAY("2000/1/1")
1
DAY("1997-04-20","yyyy-MM-dd")
20
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy