No announcement yet.

Storing Year in Database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Storing Year in Database

    I have a database column defined as datatype YEAR(4). I've tried several combinations on the SC field definition but can't seem to get a drop box with a list of just years. The SC field type is Date. There are options to use a combo box with a beginning year and then + number of years from current year. When the form displays, I see the title but the field is blank, not even a text box. Has anyone gotten the YYYY format to work with a combo box? If I don't use a combo box, a text box appears and I can manually type a year. I want to be able to have the user select a year instead of type it in.