XLSForm: How to constrain a date to be an interval between two dates

XLSForm: How to constrain a date to be an interval between two dates

To apply a constraint between two dates, enter the following syntax in the column constraint :

int(format-date(.,’%Y%m%d’)) > 20151231 and int(format-date(.,’%Y%m%d’)) < 20160201
Replace the integers by your own dates using the yyyymmdd format.

date-constraintxls

Category: Create a New Questionnaire, Questionnaires, Create Questionnaires, Questionnaire > Questionnaire

← Return to search results