I have written a page that querys a dbs, then emails according to the results. This is not working properly and I presume that the WHERE statement is wrong.
<cfquery Name="Return" Datasource="Advance">
OR (Enddate = #daysdate#)
OR (Enddate = #dayafterdate#)
OR (Enddate = #tomorrowdate#)
I need the query to retieve only records that have status onloan, and where the end date is either of the 3 above.
Please can someone confirm that this is right, or advise me on the correct WHERE statement.