• BLOG
  • Date limits when building forms

    I created a data entry form and some people typed in ‘20’ for ‘2020’ in the Date fields. We only realized this converted to the year ‘0020’ during exporting, where Excel also manipulated the dates as it cannot interpret dates prior to 1900. Is it possible to set parameters so no date prior to ‘XXXX’ year can be entered?

    Or, for example, if we could automatically default to the closest century if someone types ‘20’ (so ‘20’ would auto change to 2020 unless they specifically choose year 1920).

    No, validation on date ranges is not possible in custom fields using the default features.

    There is an add-on paid plugin which supports complex validations. Refer to https://openspecimen.atlassian.net/wiki/x/W4B_Gw for more details.