Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

 

 

  • SpongYe Profile Picture
    SpongYe 5,369 on at
    Re: Date issue - showing as US even though i have it set as local

     Sometimes the simpleist are hard to find. 

    Happy coding 🙂 

    @PowerNovice

  • PowerNovice Profile Picture
    PowerNovice on at
    Re: Date issue - showing as US even though i have it set as local

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

  • Verified answer
    SpongYe Profile Picture
    SpongYe 5,369 on at
    Re: Date issue - showing as US even though i have it set as local

    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
    PowerNovice on at
    Re: Date issue - showing as US even though i have it set as local

    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

     

     

     

     

  • SpongYe Profile Picture
    SpongYe 5,369 on at
    Re: Date issue - showing as US even though i have it set as local

    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! 🍻

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard