[resolved] HELP - HOW TO Quarter IN MY TMAP

[Anonymous]

Dear all,

I am making transformation in my tMap, and i have a column of date type, so i want to get output data each quarter of the reference date
For exemple:
INPUT DATA
Date (MM/dd/yyyy) ;  Info
03/16/2014        ;  Hello world

OUTPUT DATA         
Date (MM/dd/yyyy) ;  Info
03/16/2014        ;  Hello world
06/16/2014        ;  Hello world
09/16/2014        ;  Hello world
12/16/2014        ;  Hello world
03/16/2015        ;  Hello world
..................
...............

Thank you for help,

[Anonymous · Accepted solution]

Hi
Take a look at this built-in function: TalendDate.addDate(Date yourDateColumn, int  nb, String datePart). In this case, you need to add 3 in the month part. 
TalendDate.addDate(row1.dateColumn, 3, "MM")
Best regards
Shong