Sharepoint online datetime format

Question

Hello 

How i can convert datetime value ( 44017.6915740741 ) and time ( 0.00217592592592593 ) to normal date /time

new column with calculating but what forumula ? 

Answer 1

you can use the below formula, but i am not sure what you are asking.

=TEXT(Now(),"mm-dd-yyyy hh:mm")

https://sharepoint.stackexchange.com/questions/30050/column-calculated-value-to-get-the-current-date-time

Thanks & Regards,

---

sharath aluri

Answer 2

Hi Silver,

Use the following formula to convert the datetime value to a normal date:

=TEXT(Your datetime value column,"mm/dd/yyyy hh:mm:ss")

Result:

Use the following formula to convert the time value to a normal time:

=TEXT(Your time value column,"hh:mm:ss")

Result:

Reference:

https://support.microsoft.com/en-us/office/text-function-4b46e545-e612-4c84-ac23-edfa68007945

This “SharePoint 2013 - General Discussions and Questions” Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

Best regards,

Julie

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 3

Hi Silver,

Is there any progress on this issue?

Please feel free to reply.

Best regards,

Julie

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 4

Hi Silver,

If you find any reply helpful to you, please remember to mark it as answer.

Thank you for your understanding.

Best regards,

Julie

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 5

Hello

all work

but only  dont work =TEXT(mycolumn;"dd/mm/yyyy hh:mm:ss")

mycolumn values is 44017.6915740741 

i get same value 44017.6915740741 

Answer 6

Hi Silver,

From your post, I note you use ";" instead of ",".

Please try the following:

TEXT(mycolumn,"dd/mm/yyyy hh:mm:ss")

If you find any reply helpful, please remember to mark it as answer.

Best regards,

Julie

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 7

My sharepoint accept only ";"

Answer 8

i find problem my datetime value is with dot but when i change this to comma formula work.

But my list  items is created from excel table with flow.

Answer 9

Hi Silver,

Whether the issue has been resolved? If true, please remember to mark the post as answer.

If false, please provide more information about the list items created with flow so that I could test for you.

This forum will be locked down, if you still have issues about this question, you can continue to post in here before 8/10/2020. It is recommended to create a new question on Microsoft Q&A, we will continue to support you on the new home.

Best regards,

Julie

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 10

Hi Silver,

As the forum will be locked down on 8/10/2020, to help you better, I have created a new thread on Microsoft Q&A platform for your question. If you have any issues about this question, welcome to post it on the Q&A thread.

Thanks,

Julie

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !