Hi Folks
I just came around an issue with the DateOffsetByComponents function.
If my input date is 2014-01-29 (data type is date), and if I use the above function DateOffsetByComponents(link.column,0,1,0) - it returns 2014-03-01 which is not what I was expecting.
It looks like a bug. Just wanted to share it with everyone.
Cheers!
Issue with DateOffsetByComponents
Moderators: chulett, rschirm, roy
Re: Issue with DateOffsetByComponents
Take a look at this article.
http://www-01.ibm.com/support/docview.w ... wg1JR42002
Not so much a bug as a difference in expectations.
With an environment variable you can choose which behaviour you prefer.
http://www-01.ibm.com/support/docview.w ... wg1JR42002
Not so much a bug as a difference in expectations.
With an environment variable you can choose which behaviour you prefer.