Hi have XML field that I am extracting as one field and has timestamp of format (yyyy-MM-dd'T'HH:mm:ss.SSSSSS). Now I want to only get yyyy-MM-dd for the date comparison so that I can do the incremental load like ( yyy-MM-dd)<= 7 (for 7 days incremental). On my tjava I have: context.runDate=TalendDate.parseDate("yyyy-MM-dd","2017-07-03") On the tMap, Expression builder I have to change the format of the timestamp to yyyy-MM-dd : TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSSSSS",row2.timeStamp))) Then I have below logic for date compare: (TalendDate.compareDate(Var.datevalue,context.runDate,"yyyy-MM-dd"))<=1 When I run the job it runs fine but it doesn't load as logic but will load the entire data. Can somebody please help me on this.
... View more