You are not logged in.
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?