lundi 15 décembre 2014

How to validate on an absolute date?



I have a datetime field named "Date", and would like to only allow values within a specific range, say March 2015 - June 2016. Is there an easy way to do this? This one doesn't trigger any message:



=AND(AND(YEAR(Date) >= 2015, MONTH(Date) >= 3), AND(YEAR(Date) <= 2016, MONTH(Date) <= 6))







0 commentaires:

Enregistrer un commentaire