Date Validation Condition

Hello,

I’m struggling with a data validation… I wanted to create a date
validation so that the answer can only be between March 30, 2016 and June
30, 2016. How do I do this?

Thank you!

Hi Emily,

I think you can do this by referencing the date as an integer in the
validation condition (sorry I can’t remember the correct terminology for
this). Basically if you type “March 30, 2016” into Excel and then change
the format of the cell to “number” you will get 42459. You can then use
this in the display condition (as . >= date(42459) and . <= date(42551))

You can find additional information at the bottom of this page:
https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times

Hope this helps!

Jeremy

··· On Sun, Jul 10, 2016 at 8:56 AM, Emily Epsten wrote:

Hello,

I’m struggling with a data validation… I wanted to create a date
validation so that the answer can only be between March 30, 2016 and June
30, 2016. How do I do this?

Thank you!


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.