Dropdown Displays Available Dates Based on Database Fields
Project ID: 1329946729
Project Details
  • Status:
    Closed (Chosen Programmer: vryllesche; Paid; Rated 10 out of 10)
  • Posted:
    2/22/2012 at 16:38 EST
  • Closed:
    2/23/2012 at 2:54 EST
  • Project Creator:
    Rated 10 out of 10 for this project.
  • Budget:
    N/A
  • Description:
    ASP Page, Microsoft SQL Server database

    I have a music club SQL Server database with 7 true/false fields in each record indicating whether a club is open each day of the week. For example: Monday - False, Tuesday - False, Wednesday - True, Thursday - False, Friday - True, Saturday - True, Sunday - False.

    From this data, I need a dropdown (HTML Select box) displaying the dates the club is open for the next 3 weeks, based on the current date, and in correct order. For example, with the days of the week and true/false status described above, and beginning today (February 22nd), the dropdown would show, in order,

    February 22
    February 24
    February 25
    February 29
    March 2
    March 3
    March 7
    March 9
    March 10

    The dates must only show current and future dates, not dates previous to the day the viewer is coming into the site.
  • Tags:
Project Bids



(5 bids have been placed. stevesensei has chosen to keep all bids for this project hidden.)