Date validation in tmap with different format

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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