Skip to main content
johng58900177
Known Participant
June 5, 2019
Question

creating a schedule by week

  • 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.

    3 replies

    johng58900177
    Known Participant
    June 12, 2019

    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>

    johng58900177
    Known Participant
    June 6, 2019

    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
    Community Expert
    June 6, 2019

    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)
    johng58900177
    Known Participant
    June 12, 2019

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

    Charlie Arehart
    Community Expert
    Community Expert
    June 6, 2019

    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)