https://community.qlik.com/t5/Talend-Studio/Greater-than-function/m-p/2359074#M123968 Compare dates in expressions (e.g. tMap) using one of the following: <BR />- date1.after(date2) returns true/false <BR />- date1.before(date2) returns true/false <BR />- date1.compareTo(date2) returns 0 if equal, &lt;0 if date1 is before date2, &gt;0 if date1 after date2 Tue, 09 Apr 2013 00:38:45 GMT alevy 2013-04-09T00:38:45Z https://community.qlik.com/t5/Talend-Studio/Greater-than-function/m-p/2359073#M123967 Hi All,<BR />I am a newbie for talend. I am having a bit of a situation. I have two timestamp columns in two different tables. I want to insert values in a table when one of the column is greater than the other (both are timestamp column). I cant use tmap component as it says we are not allowed to use DATE datatype for "&gt;" function. We don't have timestamp datatype available in tmap. Please help as it's required on an urgent basis.<BR />Thanks,<BR />Vish Mon, 08 Apr 2013 14:43:44 GMT https://community.qlik.com/t5/Talend-Studio/Greater-than-function/m-p/2359073#M123967 _AnonymousUser 2013-04-08T14:43:44Z https://community.qlik.com/t5/Talend-Studio/Greater-than-function/m-p/2359074#M123968 Compare dates in expressions (e.g. tMap) using one of the following: <BR />- date1.after(date2) returns true/false <BR />- date1.before(date2) returns true/false <BR />- date1.compareTo(date2) returns 0 if equal, &lt;0 if date1 is before date2, &gt;0 if date1 after date2 Tue, 09 Apr 2013 00:38:45 GMT https://community.qlik.com/t5/Talend-Studio/Greater-than-function/m-p/2359074#M123968 alevy 2013-04-09T00:38:45Z