Adding a month in a Date column

[Gopinath]

Hi friends,

I want to add "5months and two weeks" in a date column(Timestamp).
What is the function i need to use. Can anybody help me on this.
Thanks.

[chulett]

Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp?

[Gopinath]

Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp? ...

Hi,

It's a Timestamp field. Will it work for Timestamp also. Let me try this option and also pls let me know if any other method is there for
Timestamp.

Thanks.

[Gopinath]

Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp? ...

Hi,

It's a Timestamp field. Will it work for Timestamp also. Let me try this option and also pls let me know if any other method is there for
Timestamp.

Thanks.

[chulett]

You'll need to 'remove' the time portion, work the magic on the date portion and then pop the two pieces back together, AFAIK.

[ray.wurlod]

You need to add five months then add two days, perhaps in two stage variables in the Transformer stage. This requirement can not be done as a single generic function because month lengths are unequal. Is there anything special about "five months and two days" (just curious) or is this a specific example of a more general problem to solve?

[chulett]

They stated "5 months and 2 weeks", not days. And yes, does seem like a curious interval and dependant on their definition of a month in this case.

[ray.wurlod]

Two wrongs don't make a right. But three lefts do.