Hi All,
I have a table containing Marketing offers, each of which has a start and end date.
Is it possible to create a database view which only lists the offers that are valid on the current date ?
(I.e offers whos start date <= current date and end date >= current date)
This is for use in a drop down list, where a paricular offer has to be selected.
Thanks,
Nas