Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Format DateDiff Field

Good Afternoon,

  I am pulling Data into an App to show a DateDiff. The Field is pretty tough to read as it is formatted +0000000 00:00:00.00000 . Is there a way I could use ColumnAdd( )and format that field to display better?  This field is being pulled from an Oracle Database as varchars. 

Community Support Team
Community Support Team

Re: Format DateDiff Field

Hi @RichV ,

Do you want to format your varchar field to a better displaying form?

How do you format the “+0000000 00:00:00.00000” value? It will be better if you could give me the formulas or pictures.

Could you describe more clearly about ‘display better’?

I assume that ‘+0000000’ represents date, ’ 00:00:00.00000’ represents time. And make it display better like ’0418 12:00:00’(display the part of +0000000 00:00:00.00000),

You could try this formulas:


Here’s a doc about formatting values for your reference:




Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level 10

Re: Format DateDiff Field

Thanks for posting in the community @RichV . Can you review the above reply and update the thread with the requested information so we can review for a solution?


Thank you,



Level: Powered On

Re: Format DateDiff Field

Sorry I have not responded but have been out sick and forgot about this as other stuff came up when I came back into work. Attched is a Screenshot of the Code with the highlight showing the code. I also attached a Screenshot of some data showing what it looks like. 



Helpful resources


Power Automate Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,716)