Date-Time Constraint

Question

Hi, I have a survey that workers in the field must fill out every week (On Friday). So, every answer cover from Saturday to Friday

So I created two date-time questions with starting date and ending date.

The ending date question ends 6 days after the starting date. Problem is, I need the workers only can fill the starting date on Saturdays, I mean, the survey should show a warning if the workers mark the starting date a monday.

Help.

AndyMcClary · Accepted Answer

You can get the day of the week using format-date(${YOURDATEFIELD},'%a'). Depending on how you want the warning to appear you could either have a note field that warns your user, with relevant set to: format-date(${STARTDATE},'%a')!="Sat" or put format-date(${STARTDATE},'%a')="Sat" in the constraint column of your date field.