Date in Integer YYYYMM format

[Anonymous]

Hi,

I have a situation;where my input column is an integer that holds Year and Month (YYYYMM). Now I need to now find the previous month for the incoming integer. The output column is also an integer.

For ex: 

input_col (int)                  output_col (int)

201811                            201810

201901                            201812

201906                            201905

May I know how can do the same in tmap.

[Anonymous · Accepted solution]

TalendDate.addDate(row1.input_col, "yyyyMM", -1, "MM")

you'll have to cast input_col to String to use this function

[Anonymous]

---

@evansdar wrote:

TalendDate.addDate(row1.input_col, "yyyyMM", -1, "MM")

you'll have to cast input_col to String to use this function

---

Thank you very much. Works like a charm...!!!