Remove time from DateTime field in a collection - value 2024-09-10T00:00:00

(0) Share

Report

Posted on by Cgangweg01

727 Super User 2025 Season 2

Hello -

I have a column in a collection with a date/time field formatted like this '2024-09-10T00:00:00'.

I would like to remove the time and perhaps reformat it as mm/dd/yyyy.

Below is what I've tried so far. I do not get an error with this UpdateIf statement but when I run it I get a question mark in the collection for the Price Start Date column. I've tried a few other things without success.

UpdateIf(ColStorePriceswithPromoDescrip,true,{'Price Start Date':Text(DateTimeValue('Price Start Date',"[$-en-US]mm/dd/yyyy"))});

Any suggestions?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AlfredMut 4 on at

Like (0)

Report

maybe use: formatDateTime(utcNow(),'MM/dd/yyyy')

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Thanks for the reply AlfredMut,

formatDateTime(utcNow(),'MM/dd/yyyy')'

I've used this format date function in Power Automate flows but what I can't figure out is how to apply it to the UpdateIf statement for my canvas app. collection.

UpdateIf(ColStorePriceswithPromoDescrip,true,{'Price Start Date': ....?

Any ideas?

Was this reply helpful? Yes No