cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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

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). 

image.pngimage.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

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

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,589)