• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

236

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
Community Expert ,
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 (troubleshooter, carehart.org)

Votes

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. 

Votes

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
Community Expert ,
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 (troubleshooter, carehart.org)

Votes

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.

Votes

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>

Votes

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
Resources
Documentation