topic Re: Subtract a integer from getdate in Talend Studio

Subtract a integer from getdate

Anonymous — Fri, 23 Nov 2018 08:13:32 GMT

TalendDate.getDate("yyyy") - 1 i.e i want the formula to do => "2018- 1 = 2017."

How do i make this happen?

Re: Subtract a integer from getdate

TRF — Fri, 23 Nov 2018 09:16:11 GMT

The following expression gives you the last year formatted as a String:

TalendDate.formatDate("yyyy", TalendDate.addDate(TalendDate.getCurrentDate(), -1, "yyyy"))

Hope this helps.

Re: Subtract a integer from getdate

Anonymous — Mon, 21 Jan 2019 16:34:51 GMT

Try to replace on the right side "salesforce_flattened_user.member_since" with "TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss'.000Z'", salesforce_flattened_user.member_since)".

If you want to help me write my paper, just try different options. For example, I look at how it is done for others or use different combinations until it works as I need.
For various date related schedules you can utilize the articulation developer. In the articulation manufacturer are the schedules and their utilization depicted.

Moreover, this topic has already been previously on this site, you just need to look for a solution.

Re: Subtract a integer from getdate

Anonymous — Mon, 21 Jan 2019 16:42:17 GMT

You can write me a personal message, I will explain how to do it.

Re: Subtract a integer from getdate

Anonymous — Mon, 21 Jan 2019 16:46:52 GMT

If it does not help, you can search Google or write to technical support.