I have a table with a start date and an end date. How do I get a query to produce results looking for todays date between the two listed dates?
For example:
Start Date
12/12/13
End Date
12/15/13
How does a query highlight this record in the query only whilst between these dates is todays date?