Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Subtract a integer from getdate

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

 

How do i make this happen?

Labels (2)
4 Replies
TRF
Champion II
Champion II

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

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

Hope this helps.

 

Anonymous
Not applicable
Author

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.

 

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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