Hello guys,
I found an issue when I create sharepoint Lists website.
Background:
I created a Lists website in sharepoint, then I wanna add a new column named TTID2 as below.
TTID2 is used to generate a timestamp ID for the task. So I selected a single line text for this column , and set default value as calculated value.
I used TEXT(NOW(),"YYYYMMDDHHMMSS") function to return the timestamp in string type.
Symptom
The current timestamp is 20220414112627
But the TTID column default value is TID1_20220413202627
default timestamp is 15 hours late.
However I check the website region and time zone, that is right .
I set TTID column as time Data and Time type , use NOW() function . The returned timestamp is right.
Have anyone ever encountered similar issue? Please don't hesitate to comment.
Thanks
MS