creating a schedule by week

New Here ,
Jun 05, 2019 Jun 05, 2019

Copy link to clipboard

Copied

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

Views

165

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 05, 2019 Jun 05, 2019

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.


/Charlie (server troubleshooter, carehart.org)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 06, 2019 Jun 06, 2019

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. 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 06, 2019 Jun 06, 2019

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.


/Charlie (server troubleshooter, carehart.org)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 12, 2019 Jun 12, 2019

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 12, 2019 Jun 12, 2019

Copy link to clipboard

Copied

LATEST

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>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines