In Sharepoint Lists: TEXT(NOW(),"YYMMDDHHMMSS") return wrong time value

Question

question

SunMengITC-3608 asked Apr 14, '22 YiLu-MSFT commented Apr 26, '22

In Sharepoint Lists: TEXT(NOW(),"YYMMDDHHMMSS") return wrong time value

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

office-sharepoint-online sharepoint-dev

image.png (14.6 KiB)

image.png (35.8 KiB)

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YiLu-MSFT · Apr 14 at 11:01 AM

I am currently doing some research on this issue, will let you know as soon as possible.

1 ·

SunMengITC-3608 YiLu-MSFT · Apr 14 at 11:39 AM

Thank you.

0 ·

Answer 1 · 2022-04-19T02:27:54.227Z

YiLu-MSFT answered Apr 19, '22 YiLu-MSFT commented Apr 26, '22

Hi @SunMengITC-3608
You could try to create a calculated column using formula to get the correct timestamp:

 ="TID-"&TEXT(Created,"YYYYMMDDHHMMSS")

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

image.png (38.5 KiB)

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SunMengITC-3608 · Apr 19 at 08:29 AM

Hi @YiLu-MSFT
Appreciated for your answer. But that's a workaround solution.
In the sharepoint Lists app, we wanna copy TID from one task card directly .
But if I create the TID as calculated column, it cannot be select or copy .
That's why I used the text column.

![194157-image.png ][1]

0 ·

image.png (5.0 KiB)

YiLu-MSFT SunMengITC-3608 · Apr 26 at 08:53 AM

Hi @SunMengITC-3608
I am disccussing this case with my teammate and will reply to you if we get an answer.

0 ·

question