Issue with DateOffsetByComponents

[dsetlteam]

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!

[thompsonp]

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.

[dsetlteam]

That really helps! Thanks Thompson!!!