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