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.
Lookup is failing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Lookup is failing
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]
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]