Hi,
I am trying to use a lookup for the following:
I wrote BEGIN_DT and END_DT columns from record to a Hash File, now i am trying to use a Date as ACCOUNTING_DT to look into the file to pick up the valid BEGIN_DT and END_DT.
I want to use the condition as BEGIN_DT<=ACCOUNTING_DT AND END_DT>=ACCOUNTING_DT.
When i just joins ACCOUNTING_DT from my stage to BEGIN_DT and END_DT in lookup it uses "=" (i believe).
Please tell me how to apply user defined criteria, othewise what is the procedure to achieve the same.
Thanks,
Sreenivas
User Defined Criteria in Hash File Lookups
Moderators: chulett, rschirm, roy