Forum Discussion
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 is, that the formula returns empty when the output is beyond the range of the input date (renewal date)
Below is the result if I add 1 day, or 2 days.
Any help much appreciated!
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
3 Replies
- amitchandak
Super User
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
