Answered

Dates and Time Zones

(1) Share

Report

Posted on by akharns

433

I have a date that has been stored in an Excel file. It does not have a time in it. My local time zone is Pacific, 8 hours earlier than GMT. When I try to display the date PowerApps, it consistently shows one day earlier than it should. I thought maybe PowerApps is adding a zero time and then considering it to be GMT, but that would have resulted in a later time, not an earlier time. I am not currently making any time zone corrections, which I don't actually think would be possible for a date without a time. How can I work around this, so I can display the correct date?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
@akharns

Have you tried playing around with TIMEZONEOFFSET?

DateAdd(your_date_field),TimeZoneOffset(your_date_field),Minutes)
DateAdd(your_date_field),-TimeZoneOffset(your_date_field),Minutes)

More info at the bottom of this MS Documentation

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
akharns 433 on at

Like (0)

Report

How can you do that when you haven't stored a time?

Was this reply helpful? Yes No
akharns 433 on at

Like (0)

Report

Do I need to assume that PowerApps will always incorrectly translate my dates, so I always need to convert them back by subtracting 1?

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@akharns

Yes, if you don't care about the time then just subtract by 1 like this.

DateAdd(your_date_field,-1,Days)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
akharns 433 on at

Like (0)

Report

Ok. I don't like it but at least I know. Thanks

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report

Whatever gets the job done. I mean, that's the proper maxim here, right?

If the issue is solved for now please close the thread. 😉

Was this reply helpful? Yes No