Forum Discussion
Solved
Calculated date returns blank when beyond range of input column
Hello I have some data from 2019/2020 that I am trying to 'time/shift' to 2020/2021. I am trying to do this with a new column called "projected renewal date" with the formula shown. Problem ...
JPM_Oslo , If you want add days, You can simply add a number
new date = [date]+1
new date = [date]+2
dateadd will not cross the boundary of available dates .
For month, year or day , you can also try like
new date = date(year([date])+1,month([date]),day([date]))
new date = [date]+2
amitchandak
Super User
Super UserJPM_Oslo , If you want add days, You can simply add a number
new date = [date]+1
new date = [date]+2
dateadd will not cross the boundary of available dates .
For month, year or day , you can also try like
new date = date(year([date])+1,month([date]),day([date]))
new date = [date]+2
