cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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. 

3 REPLIES 3
Highlighted
Community Support
Community Support

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:

        AddColumns('[dbo].[test412]',"fieldname2",Mid(fieldname,5,13))

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

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

 

 

 

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

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,

 

@TopShelf-MSFT 

Highlighted
Frequent Visitor

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. 

 

SQL.jpgData.jpg

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,033)