How to constraint an input (date) that is greater than the date entered previously but should be smaller or equal to the date entered today?

cta_cfah_2020 · June 17, 2021, 2:00pm

Condition: “Date must be between the date when the sample was collected and today.”

Had tried many formulas to no avail. Attached here is the error notification. Need help please.

!

Kal_Lam · June 17, 2021, 2:03pm

Welcome to the community, @cta_cfah_2020! So you mean the data could be a past date or todays date but it should not allow future dates?

wroos · June 17, 2021, 5:56pm

Welcome,
Would you mind to give the search function of this forum a trial, please?
https://community.kobotoolbox.org/search?q=date%20validation

Josh · June 17, 2021, 6:43pm

Hi @cta_cfah_2020, please refer to the support docs regarding validation:

In essence, you can do the following to solve your issue:

type	name	label	constraint
date	a_date	When did it happen?
date	another_date	When did something else happen?	. > ${a_date} and . <= today()

cta_cfah_2020 · June 18, 2021, 1:57am

Yes. The date of counting should be after the date of taking sample & today.

This is the validation code I had: .<=${today} and .>date(‘sampling_date’)

where sampling_date is the name of Q6.

cta_cfah_2020 · June 18, 2021, 2:16am

Thanks so much Josh. A lifesaver. It worked