Hi All, I know this has got to be something simple........... I'm trying to add 9years and 6 months to a date to get a reaccomplish date. I'm using =DateAdd("yyyy",+9.5,[SECURITY INITIAL]) it is not recognizing the ".5", it just adds 9years. What Am I missing. Thanks, Tim
Adding dates
- Thread starter chef_tim
- Start date
Hi
At a guess (and its only a guess) because you have specified yyyy it can only give you a full year and so rounds down to 9
Might be worth trying the DateAdd using months and adding 114 months (i.e. 9 years = 108 months + 6)
Perhaps a neater solution is there but I think this would work for what it is worth.
HTH
Best wishes
At a guess (and its only a guess) because you have specified yyyy it can only give you a full year and so rounds down to 9
Might be worth trying the DateAdd using months and adding 114 months (i.e. 9 years = 108 months + 6)
Perhaps a neater solution is there but I think this would work for what it is worth.
HTH
Best wishes
Thanks for the help. Tim
