Looking to create a schedule by week. The current DB just has the short date format in it.
What do you mean by "a schedule"? If a scheduled task, that would have nothing to do with your database. Or if you mean a web ui that looks like a schedule/calendar, I still don't see how db field formats have a connection to being able to create one.
A weekly production schedule / report. It works in ms access. Want a list of orders that are scheduled to ship for a certain week. Customers specify a date for the product to ship in the future.
Ok, yes.You can build such a thing in cfml. If you're asking how, you'll need to be more clear about where you have a problem. If you're hoping someone will respond with the code to show it, I'll leave that to others to offer.
Trying to figure out how CFML would figure out which days are in a certain week.
So something like this ( I know that this doesn't work)
<cfquery name="getdaily" datasource="dsn3">
WHERE shipdate = '#week(Now())#'