Sharepoint online datetime format

JoyZ 18,111 Reputation points
2020-08-10T07:13:21.037+00:00

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

Normally we could use TEXT(Your datetime value column,"mm/dd/yyyy hh:mm:ss") to convert the datetime value to a normal date.

OP says that his sharepoint accept only ";" rather than "," in the formula and he says datetime value is created from excel table with flow.

We need more information about the flow for further test.

Source from TechNet

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JoyZ 18,111 Reputation points
    2020-08-11T08:55:27.817+00:00

    Look forward to more information about date value created via flow from user.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.