converting UTC string to Date only

(0) Share

Report

Posted on by mrleetyler

270

hi all,

I have a Collection storing UTC date in a field.

UpdateIf(ccTasks,ID=ThisItem.ID,{ReadyTime:Text(Now(),DateTimeFormat.UTC)})

the stored data in the collection comes through as:

2021-04-18T22:35:45.665Z

i'm trying to just extract the date via:

Text(DateTimeValue(ThisItem.AircraftReady, "en-US"), "[$-en-GB]dd-mm-yyyy")

but the date reads as "19-04-2021" ...but the collection i should see "18-04-2021"

i'm guessing it's something to do with the "en-US" or [$-en-GB] but i can't figure it out to make it work and display how i want.

can someone assist please.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

HI @mrleetyler ,
The problem is that you are behind UTC, for some of the day (I have the opposite issue being 10 hours ahead). You need the TimeZoneOffset function which returns the difference between the user and UTC. You just add this to UTC.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
mrleetyler 270 on at

Like (0)

Report

but if the collection is already
2021-04-18T22:35:45.665Z

why can't PA just pull the date like it can the time? why does it change it to todays date. 😞

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
HI @mrleetyler ,

Just did some experimenting here - using the collection value

ClearCollect( colUTC, { UTCVal: Text( Now(), DateTimeFormat.UTC ) } )

gets one record exactly like yours (showing UTC time which is 10 hours behind) - then I put another label with this

and got the correct time here - I do not need TimeZoneOffset - it just worked it out - you might see where yours is different.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
mrleetyler 270 on at

Like (0)

Report

thanks @WarrenBelz

i tried this on an isolated environment and it worked fine, if i did now()-1 it changed the date as we'd expect.

will play around with it in my live envrionment to get it working as above 🙂

thanks again

Was this reply helpful? Yes No