Dates and Time Zones

[akharns]

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?

[mdevaney]

@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."

[akharns]

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

[akharns]

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

[mdevaney]

@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."

[akharns]

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

[mdevaney · Accepted solution]

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. 😉