topic Date validation in tmap with different format in Talend Studio

Date validation in tmap with different format

Anonymous — Fri, 14 Mar 2014 10:59:35 GMT

Hi, i have a main table, TABLE_A with .
TABLE_A is in join on CODE with lookup table, TABLE_B
what i want is to take only records where DATE is between DATE1 and DATE2.
Additional problem: TABLE_A.DATE is a string like this yyyyMMdd eg.20001231
TABLE_B.DATE1,DATE2 is a date like this dd-MM-yyyy eg.31-12-2000

Re: Date validation in tmap with different format

Anonymous — Fri, 14 Mar 2014 11:19:05 GMT

You should convert all columns you want to use in a join into appropriated data types -> Date!
You can do the job with the tMap.

Re: Date validation in tmap with different format

Anonymous — Fri, 14 Mar 2014 13:51:40 GMT

You should convert all columns you want to use in a join into appropriated data types -> Date!
You can do the job with the tMap.

hi, before and after functions not working
i thought i should use compareDate(DATE,DATE1)>=0 && compareDate(DATE,DATE2)<=0

Re: Date validation in tmap with different format

Anonymous — Fri, 14 Mar 2014 15:55:28 GMT

i also have a TIME table which contains dates in many different format, maybe can be useful to join it too