question

JoyZ avatar image
0 Votes"
JoyZ asked JoyZ answered

Sharepoint online datetime format

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


office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

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

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered

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

5 |1600 characters needed characters left characters exceeded

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