Sharepoint list colume date validation

%3CLINGO-SUB%20id%3D%22lingo-sub-546400%22%20slang%3D%22en-US%22%3ESharepoint%20list%20colume%20date%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-546400%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20ask%20your%20help.%3C%2FP%3E%3CP%3EI%20have%20a%20column%20(date)%20with%20validation%2C%20but%20it%20is%20not%20working%20due%20to%20timezone%20differences.%3C%2FP%3E%3CP%3EThe%20formula%20what%20i%20used%20so%20far%3A%3C%2FP%3E%3CP%3E%3DOR(ISBLANK(Returning_date)%2CReturning_date%3DToday())%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20if%20set%20the%20date%20to%20Today%20before%209%3A00AM%20it%20says%20failed%20the%20validation.%3C%2FP%3E%3CP%3EAfter%20some%20test%20and%20using%20the%20NOW()%20calculation%20turned%20out%20the%20SP%20list%20sense%20the%20date%2Ftime%20-9%20hours%20to%20my%20actual%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20case%20i%20do%20not%20use%20the%20Time%2C%20only%20the%20date%20(day)%20validation%20is%20important%2C%20can%20you%20please%20help%20how%20to%20fix%20this%3F%3C%2FP%3E%3CP%3EI%20am%20editing%20the%20data%20directly%20in%20the%20Sharepoint%20list%2C%20and%20it%20can%20be%20empty%20or%20only%20the%20Today%20date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-546400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

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

0 Replies