Start and End dates validations in Sharepoint list

Question

Hi all,

I am working on a requirement in Sharepoint list, which requires me to create two columns of date and time type namely "Start Date" and "End Date" to record start & end timings along with respective dates. My requirement is:

Start Date=06/24/2022 9:00 am

End Date=06/24/2022 11:00 am

End Timing > Start Timing and both dates should be same.

I have tried list validation settings, for the timing part. But how to club both the conditions under list validation settings option & what should be the date condition?

Answer 1

Dear Aisha,

Thank you for the reply.

For your requirement, you can try this formula:

=AND(YEAR([Start date])=YEAR([End date]),MONTH([Start date])=MONTH([End date]),DAY([Start date])=DAY([End date]),[End date]>[Start date])

Sincerely,

Jazlyn | Microsoft Community Moderator

Answer 2

Dear Aisha,

Good day! Thank you for posting your query in our community. We are happy to help you.

For your requirements, you can try the following formula:

=AND(DAY([Start date])=DAY([End date]),[End date]>[Start date])

Please note that for a column validation, you can’t reference other columns for this type of validation. So you need to use the List validation via List settings > Validation settings >  enter the formula above.

Sincerely,

Jazlyn | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

Answer 3

Hi,

Thankyou for your response. My query now is, what if user by mistakely adds incorrect month.

E.g. Start Date=06/30/2022 9:00 am

End Date=07/1/2022 11:00 am

I have tested using the formula provided, but it doesn't fulfill this condition. Can you please help?