How to limit date format on Xlsx-form

Support
,
1

1. What is the problem? Be very detailed.
I can not limit date format on odk form by using Excel sheet

2. What app or server are you using and on what device and operating system? Include version numbers.
Xlsx-form, ODK collect, Microsoft Excel

3. What you have you tried to fix the problem?
I have tried to make limitation on date but does not work e.g from 2019 to 2022

4. What steps can we take to reproduce the problem?
Can you explain to me how to use clear codes in making date limitation on Xlsform

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

This are my data Seqa01.xlsx (12.7 KB)

2

Hi @Melkiory

here is a topic which should help you Constraint on date or this Date constraint
Basically you need to use constraint column and use something like:
.>=date('2019-01-01') and .<=date('2022-12-31')

1 Like
3

Thank you so much @Grzesiek2010
Let me check try the codes and reading what is inside the links