Answered

Removing time from a date field not working

(0) Share

Report

Posted on by Lefty

1,625

I have the following on a label inside a gallery - I vaguely recall this worked as expected, but now no longer does, it no longer removes the time from the text and displays as :

2022-08-12T00:00:00

My Text Property:

Text(ThisItem.EStart, "dd-mm-yyyy")

Clearly both the formatting is wrong and the fact the time is showing, can't see why it wont display as dd-mm-yyyy and omitting the time, any ideas?

I should mention (don't know it it affects anything) this label is in side a nested gallery - and the nested galleries Items property is set to:

ThisItem.GroupedDATA

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Jeroen J on at

Like
a
(3)

Report
Copy link

Link copied!

Not sure, but you could try using DateValue:

DateValue(ThisItem.'Created On') results in 2/3/2023

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @jonckhje
That wouldn't work as SQL doesn't have a CreatedOn value

Sorry I should have mentioned SQL is the data source

Was this reply helpful? Yes No
Jeroen J on at

Like
a
(0)

Report
Copy link

Link copied!

Okay, but regardless of the source, what happens if you try DateValue(ThisItem.Estart)

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

The same as Text(ThisItem.EStart, "dd-mm-yyyy")

Displays the same values
2022-08-12T00:00:00

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm thinking maybe an option to remove everything and including 'T'

Still wont solve the formatting of the date to DD MM YYYY though

Was this reply helpful? Yes No
Jeroen J on at

Like
a
(0)

Report
Copy link

Link copied!

Wow... this is getting puzzling... I tried it in a sandbox environment and got exactly the wanted result:

Obviously we're doing something different. Could you see what it might be?
(besides the data source and fields of course, that shouldn't matter)

Was this reply helpful? Yes No
Jeroen J on at

Like
a
(0)

Report
Copy link

Link copied!

Wow... this is getting puzzling... I tried it in a sandbox environment and got exactly the wanted result:

Obviously we're doing something different. Could you see what it might be?
(besides the data source and fields of course, that shouldn't matter)

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure, if its to do with your CreatedOn being a system field in SP. Don't know if that is a like for like check, but I know the function I have should work, even before posting my question, but I can't understand why it doesn't

Was this reply helpful? Yes No
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
It's odd

when I change my code to directly querying SQL the date is correctly formatted
GroupBy( Search( Filter( //colSQLView, SQL_view,
But changing it to the collection, it doesn't and it shows in this format 2022-08-12T00:00:00

I am creating the collection a Stored Procedure through PowerAutomate:
ClearCollect(colSQLView1, SQL_view_Flow.Run().ResultSets.Table1);
If i dont use PowerAutomate and load the data in the collection directly via SQL I don't get the T00:00:00, it's only when I use the flow, issue is I need to use the flow as my data is non delegable otherwise

Was this reply helpful? Yes No
Verified answer

Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!

i got this working by setting the text value to:

Left(ThisItem.EStart, Len(ThisItem.EStart) - 9)

Was this reply helpful? Yes No