Add or minus offset (DAY,HOUR,MIN,SEC ) with datetime then we can use below one.
Use new Column with below formula
[DateTime] + #duration(0,10,0,0)
##duration(DAY,HOUR,MIN,SEC)
-------------------------------------------------------------
Add or minus offset (DAY,HOUR,MIN,SEC ) with datetime then we can use below one.
Use new Column with below function.
DATEDIF(date1,date2,interval)
Interval : DAY/MONTH/YEAR.
--------------------------------------------------------------
To get the current date use TODAY() or NOW()
No comments:
Post a Comment