I am converting old Access DB’s to SQL and writing a CF app. I want to print a report that for shipments per week. How can I query a table with a ship date of 06/04/2019 and return everything that needs to be shipped in that week? The daily WHERE statement is WHERE shipdate = ‘#DateFormat(Now(), “mm/dd/yyyy”)#’