May 08 2019 05:05 AM
Dear Community,
I would like to ask your help.
I have a column (date) with validation, but it is not working due to timezone differences.
The formula what i used so far:
=OR(ISBLANK(Returning_date),Returning_date=Today())
My problem if set the date to Today before 9:00AM it says failed the validation.
After some test and using the NOW() calculation turned out the SP list sense the date/time -9 hours to my actual time.
In my case i do not use the Time, only the date (day) validation is important, can you please help how to fix this?
I am editing the data directly in the Sharepoint list, and it can be empty or only the Today date.
Thank you