Forum Discussion
lemgab0404
Oct 12, 2023Copper Contributor
Creating a complex date validation formula for a sharepoint list
to put you in context this sharepoint list is used for employee to exchange shift. They input the date they give and the date they receive. I want to validate that either of the dates are inside 30 days and both are in more than 24 hours.
=OR( DATEDIF( [Created],[Date1],"d")<30, DATEDIF( [Created],[Date2],"d")<30)
I receive an error saying that either the syntax is wrong or the formula is not supported I also didn't manage to add the 24 hours condition.
No RepliesBe the first to reply