One Star

Lookup with between clause

Below is the scenario
Input table has a date column say input_date_col
Lookup table has columns start_date and end_date and lookup_key column
I need to return lookup_key column when input_date_col is between start_date and end_date.
I tried putting this information in the lookup but it gives me an error. Is there a way to do this?
2 REPLIES
Seven Stars

Re: Lookup with between clause

One Star

Re: Lookup with between clause

Thanks this worked! Appreciate your help.