I have a table with records that include a startdate and enddate field. The stardate and enddate for a record could be the same or differ by days, weeks or months.
I have a query that will retrieve all records where the current day is on or between the startdate and enddate i.e. startdate<=Date() AND enddate>=Date()
I also require a query that will retrieve all records for the current week. Can anyone give me some advice on how to achieve this?
I have a query that will retrieve all records where the current day is on or between the startdate and enddate i.e. startdate<=Date() AND enddate>=Date()
I also require a query that will retrieve all records for the current week. Can anyone give me some advice on how to achieve this?