The Condition for my lookup is if my input date is between the start date and end date then to retrieve the start and end date. The end date could have nulls ( to indicate that they do not expire )
My lookup table has a custom SQL like the following ?
WHERE TBL_TEST.TEST_ID=? AND TBL_TEST.EFF_DATE<=? AND TBL_TEST.EXP_DATE > ?
The above does not handle the case if the exp is null ...how do I accomadate that ?
Lookup concerning date in between
Moderators: chulett, rschirm, roy
You didn't specify a database, so...
Code: Select all
AND (TBL_TEST.EXP_DATE > ? OR TBL_TEST.EXP_DATE IS NULL)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers