Unanswered

Excel integer formatted date/time value?

(0) Share

Report

Posted on by DeeJay

I know that addDays(‘1899-12-30’,int(item()[‘Date’]),’yyyy-MM-dd’) can be used to convert an integer (e.g .37569444444) formatted date value coming from excel but what expression is there to use for converting date AND time?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-litu-msft on at

Like (0)

Report

Hi @DeeJay,

Could you share a screenshot of the date AND time in the excel file?

How do you format the Date & time column in the Excel file?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
DeeJay 2 on at

Like (0)

Report

The data in the excel table is populated from Forms. The date and time timestamp in the excel column is formatted as mm/dd/yyyy hh:mm:ss of ‘custom’ data type. In a html table output action it comes out as interger, e.g 43637.456412307.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @DeeJay,

I think this post will help you convert the timestamp into Date:

https://powerusers.microsoft.com/t5/Building-Flows/Convert-Excel-date-value/td-p/105686

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No