Date Picker Sends Wrong Date

[Shay8080]

Hi, 

I am working with powerapps by using excel file that saved on my oneDrive.

I have an issue with dates.

The user selects a date by using the date picker 

the date look ok on the UI but, the excel got the wrong date  ( minus one day ) 

see pictures

 

[eka24]

Check this similar post
https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-Picker-Changes-to-Wrong-Date/m-p/378030

[Shay8080]

Already tried that, not works for me 

[Pstork1]

The post @eka24 referenced is the right solution.  The problem is that Dates always contain a time component.  When the user picks a date using the date picker its defaulting to midnight on that date in the user's current timezone.  But when it saves it to Excel its converting to UTC, which is evidently two hours before your current timezone. So the date becomes yesterday at 10:00 PM UTC instead of today at midnight local time. 

To fix it you need to adjust the time added to the date picker when it stores the value in Excel.

[v-yutliu-msft · Accepted solution]

Hi @Shay8080 ,

Do you mean that the time in Excel is different from the time loading in PowerApps?  

The reason why you met this problem is that:

Excel's default time zone is UTC.

PowerApps' default time zone is local time zone.

So when PowerApps load time, it will transfer to local time automatically.

In order to solve the problems mentioned above,I suggest you save local time to Excel and load time in PowerApps as local time too.   //make time zone the same.

I’ve made a similar test for your reference:

Step1:Set the Default of the Date DATA CARD (not the Default on the Date picker) to

DateAdd(ThisItem.Date,TimeZoneOffset(),Minutes)

Step2:Set the Update of the Date DATA CARD (not the Default Date on the Date picker) to

DateAdd(DateValue10.SelectedDate,-TimeZoneOffset(),Minutes)

Step3:Make sure the Date time zone properties of the date picker control is “Local”

Best Regards,

[Shay8080]

Thanks !!

This Solution Works Perfect !! 😀

[eka24]

Mark the answer as a solution

[Madiko]

it doesn't work for me. Nothing changed when I follow this solution. I still have time stamp in my excel file. Can anyone help? I need to remove timestamp from excel when I submit a form in PowerApps.

[Pstork1]

The time stamp in Excel is dependent on the formatting of the Excel column, not the way the time is submitted from Power Apps.  Make sure the Excel cells are formatted as either Short Date or Long Date, not one of the custom date formats.