johng58900177 | ColdFusion

Query by week

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”)#’

Can I use Cold Fusion Builder to auto generate forms and queries?

Back in the earlier days of CF, I was able to generate pages out of CFStudio. I have been away from it for a long time and am wondering if I can do this in CFBuilder 2018.