One Star

Date validation in tmap with different format

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
3 REPLIES
Seventeen Stars

Re: Date validation in tmap with different format

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.
One Star

Re: Date validation in tmap with different format

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
One Star

Re: Date validation in tmap with different format

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