Skip to main content
Inspiring
October 12, 2018
Question

Multiple date field comparison

  • October 12, 2018
  • 1 reply
  • 409 views

I have a form with multiple date fields (5) that need to be validated against one "first" date field. I haven't been able to get it to work with the scripts that I've found online.

Hopefully the screenshot that I'm including makes sense.

All of the date fields following "Date first case became ill" cannot be dates before that date.

I appreciate any help provided.

This topic has been closed for replies.

1 reply

Inspiring
October 13, 2018

Have you tired to convert the date string to a format that is can be sorted?

One could also convert the dates to a unique numeric value where the value of each day maps to a ascending number line.

Inspiring
October 18, 2018

Thanks for your input. These sound like great ideas but I wouldn't know how to do that.

Could I be overcomplicating things and just need something in each subsequent field that checks its value against the first field?