creating a schedule by week

Forum|Forum|6 years ago
June 5, 2019
3 replies
379 views

Looking to create a schedule by week. The current DB just has the short date format in it.

This topic has been closed for replies.

johng58900177Author

Known Participant

So something like this ( I know that this doesn't work)

Select shipdate,buyername,shiptoname,quantitytotal,label,packstyle,buyerpo,totalsale,ponumber

FROM purchaseordertable

WHERE shipdate = '#week(Now())#'

</cfquery>

johng58900177Author

Known Participant

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.

Charlie Arehart

Community Expert

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.

/Charlie (troubleshooter, carehart. org)

johng58900177Author

Known Participant

Trying to figure out how CFML would figure out which days are in a certain week.

Charlie Arehart

Community Expert

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.

/Charlie (troubleshooter, carehart. org)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded