Unable to store the Date Format in Excel as DD/MM/YYYY. Using Power Apps Date Picker.

[Kishorep]

Hi , I am pretty new to this PowerApps. I am trying to store the date in dd/mm/yyyy format. I tried finding a solution from other posts and ended up in just making them to view in DD/MM/YYYY format. I tried using the following and

ended up in getting the wrong result (I mean I am picking a date as feb 12 2019 and its storing in execel as 02/01/2020). 

[v-xida-msft · Accepted solution]

HI @Kishorep,

Do you format a column as a Date type column in your Excel table to store the Date value picked from your app?

Actually, the Date Value format stored within your Excel table based on which Date format you set the Date column to in your Excel table.

In other words, if you want to store the Date Value format in your Excel table as "dd/mm/yyyy", you must format the Date column in your Excel table as "dd/mm/yyyy".

In addition, as an alternative solution, you could consider add a Normal Text column (DateOfContact1) to store the Date value picked from your app instead of Date type column in your Excel table. When you generate an new app based on your modified Excel table, the DateOfContact1 column would be decorated as a Text Input box rather than a DatePicker control in your Edit form.

After that, you could take a try to remove the Text Input box within DateOfContact1 Data card, then add a Date Picker control within it. Set the Update property of the DateOfContact1 Data card to following:

Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy") /* <-- Type Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy") rather than DateValue(Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy"))*/

Please check the attached GIF screenshot for more details:

Best regards,