Unanswered

Format DateDiff Field

(0) Share

Report

Posted on by RichV

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.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,

@Anonymous
RichV 26 on at

Like
a
(0)

Report
Copy link

Link copied!

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.