[resolved] date math - how can Talend add or subtract X number of days?

[talendtester]

How can you add or subtract X number of days with Talend?
For example my date is '2013-04- 22' how can Talend subtract 5 days and return '2013-04- 17'?

[_AnonymousUser · Accepted solution]

You can use following expression to move date 5 days back

TalendDate.addDate("2013-04-22","yyyy-MM-dd",-5,"dd")

[talendtester]

Thanks oz69! Works great.

[tYrannoSaurusRex_1]

I have a excel sheet where Column B is a date and Column E is a number. I want number of days in Column E to be reduced from Column B and stored in Column F
Input be like,
Column B|Column E|Column F
2014-05-13|4|
2014-06-12|2|
Output be like,
Column B|Column E|Column F
2014-05-13|4|2014-05-09
2014-06-12|2|2014-06-10
Anybody up for help??

[Jcs19]

hi guru,
use tmap

Expression of column F:
TalendDate.addDate(row1.columnB,"yyyy-MM-dd",-row1.columnE,"dd")

[tYrannoSaurusRex_1]

Hi Jcs19,
You are subtracting date from date... I need to subtract number of days from date...

[Jcs19]

Hi Jcs19,
You are subtracting date from date... I need to subtract number of days from date...

What?
I thought you wanted column F = Column B(date) - Column E(number of day)
In my example, i'm subtracting column E as number of day to column B to make column F

[tYrannoSaurusRex_1]

but the datatytpe shown in expression editor is date and not integer

[Jcs19]

but the datatytpe shown in expression editor is date and not integer

Oh yes, column E should be integer not date (I made this example too fast )