cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Excel integer formatted date/time value?

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?
3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Excel integer formatted date/time value?

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.

Highlighted
New Member

Re: Excel integer formatted date/time value?

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.
Highlighted
Community Support
Community Support

Re: Excel integer formatted date/time value?

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.

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,461)