Forum Discussion

lemgab0404's avatar
lemgab0404
Copper Contributor
Oct 12, 2023

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

Resources