Copy link to clipboard
Copied
Looking to create a schedule by week. The current DB just has the short date format in it.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
Trying to figure out how CFML would figure out which days are in a certain week.
Copy link to clipboard
Copied
So something like this ( I know that this doesn't work)
<cfquery name="getdaily" datasource="dsn3">
Select shipdate,buyername,shiptoname,quantitytotal,label,packstyle,buyerpo,totalsale,ponumber
FROM purchaseordertable
WHERE shipdate = '#week(Now())#'
</cfquery>