_add_days function

[billylodz]

have you ever seen something like that

RS 8.3

every run this expresion gives different result, do you have any idea, seems it's problem when using  (_add_days + cast) together


_add_days ( cast('2009-01-01',DATE), 1 )

[thrishul]

did you check in 8.2

its working fine!

[Suraj]

8.3.
It gives a different date than expected with that combination and syntax. That's not what I expected.

But, your combination of cast and _add_days works if you remove the single quotes around the date:
_add_days ( cast(2009-01-01,DATE), 1 )

[billylodz]

Thanks for input

In fact in my case the date was string because was taken from otherstring combinations, but it works also with _make_timestamp


something like:
_add_days(CAST(_make_timestamp(2009,09,16),DATE),1)
where 2009,09,16 I take from string

Thanks