Date Picker Sends Wrong Date

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

eka24 20,923 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Shay8080 5 on at

Like (0)

Report

Already tried that, not works for me

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (6)

Report
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,

Was this reply helpful? Yes No
Shay8080 5 on at

Like (0)

Report

Thanks !!
This Solution Works Perfect !! 😀

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Mark the answer as a solution

Was this reply helpful? Yes No
Madiko 37 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No