Working with Powerapps 2.0.460, Windows 10, IPad app, connection to SQL Azure (for Access Web App in Sharepoint online), local settings for UK on PC and Ipad, date format dd/mm/yyyy
The date returned to the server from a DatePicker control is consistently one day less than the date entered. So enter, say, April 7th 2016 on the PowerApp Datepicker (either from F5 on the PC or from the app on the IPad), save, look at the SQL AZure record and it has April 6th 2016. Same over a month boundary - enter 1st May, get 30th April.
The card Update setting is valDateOfBirth.SelectedDate. I've tried Text(valDateOfBirth.SelectedDate,"dd/mm/yyyy") as well but the result is the same.
Looks like a bug...??
Solved! Go to Solution.
I am currently executing a migration to O365 and I am having a similar issue when uploading data to a new SharePoint Online list, where all DateTime fields are off by -1 day.
Is this an issue with Time-Zones or a bug?
Any updates would be appreciated.
Ever found a solution? My SPO list also saves entries with one day off. Date fields in powerapps form are set to UTC and my spo site is in utc...
I created a new integer column on SQL Server to solve my problem as a poor man's work around based on a suggestion someone else had.
Use this code on SQL Server to create new integer columns that work beside your date column in a YYYYMMDD format.
alter table TestTableName
add PickupDatePA as (CONVERT(int, DATEPART(year, PickupDate)) * 10000 + CONVERT(int, DATEPART(month, PickupDate)) * 100 + CONVERT(int, DATEPART(day, PickupDate)) * 1) persisted,
DeliveryDatePA as (ConVERT(int, DATEPART(year, DeliveryDate)) * 10000 + CONVERT(int, DATEPART(month, DeliveryDate)) * 100 + CONVERT(int, DATEPART(day, DeliveryDate)) * 1) persisted
Now do your sort and filters using the new PA columns.
I should note that I gave up on Power Apps and went back to making my own web apps. Idea behind Power Apps is great, but if you cannot do simple filters and searches on date columns which to me is a must, it just does not work well in my environment. There was too many glitches for me that I had to try and find work arounds for.
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT