Highlighted

creating a schedule by week

New Here ,
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

145

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

creating a schedule by week

New Here ,
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

146

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
Jun 05, 2019 0
Adobe Community Professional ,
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
Reply
Loading...
Jun 05, 2019 0
New Here ,
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
Reply
Loading...
Jun 06, 2019 0
Adobe Community Professional ,
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
Reply
Loading...
Jun 06, 2019 0
New Here ,
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
Reply
Loading...
Jun 12, 2019 0
New Here ,
Jun 12, 2019

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>

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
Reply
Loading...
Jun 12, 2019 0