Custom Format a Date Time

(0) Share

Report

Posted on by Mattw112b

1,088

I have a date AND time field from SharePoint List Item.

I want to apply a custom format to it to shorten it.

So instead of "March 26th, 2020 16:25 PM" I would want "3/26 @4:25 PM"

I tried:

Text(ThisItem.'Next Steps Date', "[$-en-US]m/d @ hh:mm AM/PM" )

But it comes out as: "3/27/2001"?

THanks,

Terry

Categories:

Building Power Apps

All responses (14)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Mattw112IG
Try this
Text(ThisItem.'Next Steps Date', "m/d"&" @"&"hh:mm AM/PM")
Mattw112b 1,088 on at

Like
a
(1)

Report
Copy link

Link copied!

displays the same?
Terry
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Strange, it works for me. Did you copy and paste the code I suggested?
Mattw112b 1,088 on at

Like
a
(0)

Report
Copy link

Link copied!

Yep, see below:

Starting date from SharePoint:

After your edit:

Terry
Mattw112b 1,088 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure if this is related but this is no longer working today, was working yesterday:
Text(
(Value(DataCardValue5.Text) - PRBurden) / Value(DataCardValue5.Text),
"[$-en-US].##0"
)

Used to return three places.. now only returning two??

Terry
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Mattw112IG
There's a comma at the end of your formula, is your Text() formula part of an If() statement? Also, is this in a gallery or a Form? If a Form, what are the relevant properties of the DataCard?

For you three decimal places, try 000 instead of ##0.
Mattw112b 1,088 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes part of an if...

On a gallery

Thanks,
Terry
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share it? it maybe relevant. Seeing as the dates are mismatching I'd say the If() isn't making it to this statement.

To test this theory, try putting a label in your gallery with the above code only.
Mattw112b 1,088 on at

Like
a
(0)

Report
Copy link

Link copied!
When I change, just this piece of the If, it changes the format. So I think that is happening correctly... but full is:

If( ThisItem.'Next Steps' = "START", ThisItem.'Start Date', If( ThisItem.'Next Steps' = "Phone Screen" || ThisItem.'Next Steps' = "Interview" || ThisItem.'Next Steps' = "Final Interview", ThisItem.'Next Steps Date', "" ) )

This displays the full date and time.

When I change just the line I've shown in the clips, it changes to 2001.

Thanks,
Terry
Mattw112b 1,088 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried as you suggested and added a new label and it does work... weird..

Terry