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?
Solved! Go to 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. 😉
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."
How can you do that when you haven't stored a time?
Do I need to assume that PowerApps will always incorrectly translate my dates, so I always need to convert them back by subtracting 1?
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."
Ok. I don't like it but at least I know. Thanks
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. 😉
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
196 | |
174 | |
62 | |
33 | |
32 |
User | Count |
---|---|
339 | |
270 | |
109 | |
76 | |
59 |