web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Date Picker - showing ...
Power Apps
Unanswered

Date Picker - showing as US even though i have it set as local

(0) ShareShare
ReportReport
Posted on by

Hi, 

 

I have managed to format this date in my gallery when it pulls through by using the text function and defining how i want it to look. However, this wouldnt work for "date&time" data card. 

 

How do i make this into UK date (dd/mm/yy), not US (mm/dd/yy)?

 

PowerNovice_1-1696590535936.png

 

PowerNovice_0-1696590493559.png

 

 

Categories:
I have the same question (0)
  • SpongYe Profile Picture
    5,603 Super User 2025 Season 2 on at

    Hi @PowerNovice 

     

    To change the date format in a Date & Time data card, you can use the Text function to specify how you want the date to look like. For example, if you want to display the date as dd/mm/yy, you can use this formula:

    Text (ThisItem.Date, “dd/mm/yy”)

    Where ThisItem.Date is the name of your date column in your data source. You can replace it with your own column name.

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • PowerNovice Profile Picture
    on at

    How does that work when the date is derived from the below (Calendar)? I cant find the "text" attribute in the dropdown. I have tried to use the text function already, and it works fine in my gallery where i'm displaying the contents of this date within a text field. 

     

     

    PowerNovice_2-1696596697711.png

     

     

     

     

  • Verified answer
    SpongYe Profile Picture
    5,603 Super User 2025 Season 2 on at

    Hi @PowerNovice 

     

    Please use the Format function in the DatePicker and change the format to:

    “dd/mm/yy”

    SpongYe_0-1696597123972.png

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

     

  • PowerNovice Profile Picture
    on at

    Thank you! Can't believe it was that simple and that i completely overlooked that. I thought it needed to stay as "shortdate". 

  • SpongYe Profile Picture
    5,603 Super User 2025 Season 2 on at

     Sometimes the simpleist are hard to find. 

    Happy coding 🙂 

    @PowerNovice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard