Page 1 of 1
Lookup is failing
Posted: Wed Jul 19, 2006 9:55 pm
by Ratan Babu N
Hi,
In my Job, I am doing a Lookup on a field which is Date 10 but my source is Date 8 . Will it Pass the record.If not how can i pass the Look up.
Posted: Wed Jul 19, 2006 10:02 pm
by ray.wurlod
They must be 100% compatible. Make it so.
Posted: Thu Jul 27, 2006 2:46 am
by iamnagus
From the lookup reference, Apply like this:
Link_Name.Date[1,8] and do the lookup with source.
Posted: Thu Jul 27, 2006 4:26 am
by ray.wurlod
I doubt that this will work; the [ ] indicate a substring operation, but the data type is date, not string.
Posted: Fri Jul 28, 2006 1:07 am
by iamnagus
[I doubt that this will work; the [ ] indicate a substring operation, but the data type is date, not string]
Ray,
You are right. while giving the answer, i had not put data types in mind.
Regards,
iamnagus[/quote]
Re: Lookup is failing
Posted: Sun Jul 30, 2006 11:25 am
by kura
I double [] will work. If it data type "DATE", then there is no "DATE" of length 8 and "DATE" of length 10. "DATE" is Date, there is no significance for length.
My assumption you are using two field of one with char(8) other wth char(10). Then you must make same length and contect same format.
[quote="Ratan Babu N"]Hi,
In my Job, I am doing a Lookup on a field which is Date 10 but my source is Date 8 . Will it Pass the record.If not how can i pass the Look up.[/quote]