Validate Dates

[HTML]

db = DAL('sqlite://storage.sqlite')

db.define_table(

    'interns',

    Field('intern_id','id'),

    Field('first_name','string',default=""),

    Field('last_name','string', default=""),

    Field('phone_number', 'string', default=""),

    Field('legal_representative', 'string', default=""),

    Field('representative_phone_number', 'string', default=""))

db.define_table(

    'mentors',

    Field('mentor_id','id'),

    Field('trading_name','string', default=""),

    Field('first_name','string', default=""),

    Field('last_name','string', default=""),

    Field('phone_number', 'string', default=""),

    Field('fax', 'string', default=""),

    Field('email', 'string', default=""))

db.define_table(

    'internships',

    Field('intern_id','reference interns'),

    Field('mentor_id','reference mentors'),

    Field('course_name','string', default=""),

    Field('start_date','date'),

    Field('end_date', 'date'))

db.define_table(

    'attendances',

    Field('intern_id','reference internships', onupdate = 'CASCADE'),

    Field('mentor_id','reference internships', onupdate = 'CASCADE'),

    Field('attendance_date','date', default=request.now),

    Field('clock_in','time'),

    Field('clock_out','time' ))

db.interns.first_name.requires = IS_NOT_EMPTY()

db.interns.last_name.requires = IS_NOT_EMPTY()

db.mentors.first_name.requires = IS_NOT_EMPTY()

db.mentors.last_name.requires = IS_NOT_EMPTY()

db.internships.course_name.requires = IS_NOT_EMPTY()

db.mentors.email.requires = [IS_EMAIL(), IS_NOT_IN_DB(db, 'mentors.email')]

My code its like this i want to know how i make a range between the internships start date and end date like the user just can choose a date between that not before or after.

[villas]

To validate a field within a range, use is_date_in_range

To validate fields in relation to each other after form submission, use onvalidation

You could of course also validate the dates using jquery prior to form being submitted.