Sharepoint online datetime format

JoyZ 18,041 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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,728 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JoyZ 18,041 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