Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compare two dates and get the latest one

i wanted to compare two dates in talend and pick the most future date take for example 20150302 and 20010323 then i pick 20150302 how can i write this in tmap?

Labels (2)
2 Replies
Anonymous
Not applicable
Author

You can use the built-in function TalendDate.compareDate(parameters list) to compare two date, eg:
TalendDate.compareDate(row1.date1, row1.date2)>1? row1.date1:row1.date2
Anonymous
Not applicable
Author

Hi Wilson

I've also found another solution to that in this topic:

Comparing Dates in tMap(search this in google):

https://community.talend.com/t5/Design-and-Development/resolved-Comparing-Dates-in-tMap/m-p/103376

I think you can find this helpful
I hope you can resolve your problem 0683p000009MACn.png



Locke