• Scheduleing database (97)

    • This topic has 1 reply, 2 voices, and was last updated 19 years ago.
    Author
    Topic
    #430735

    I have created a very small scheduling system and now the boss wants to make some changes. Currently, if you need to schedule a class for 3 days, you have to enter each day separately. I need some assistance on how to schedule 3 days ( or more) at one time. She does not like doing each day individually. I would like to put a start date and ending date and then let the database populate all the other fields. I also need for it to jump over the weekends. We do not work on the weekends. I may have a class on Tues, Thur and the following Tues.

    Any ideas! You guys are always so helpful.

    Viewing 0 reply threads
    Author
    Replies
    • #1006625

      If you have a class on Tuesday, Thursday and the following Tuesday, I don’t see how the dates could be generated automatically from a specified start date and ending date.

      The attached database shpws how to create a series of contiguous dates (excluding weekend days, not taking holidays into account). It’s just meant as a demo, not as a finished application.

    Viewing 0 reply threads
    Reply To: Scheduleing database (97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: