Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Date will not show in the correct format of dd/mm/yyyy

Posted on 19 Nov 2024 04:57:14 by 17
Howdy!
 
So i'm creating my first Dataverse for Teams canvas app and i am struggling with the date format. In the dataverse table it shows as mm/dd/yyyy even though my regional settings are set to Australia.

 
In the form in my app, it also displays as mm/dd/yyyy.
 

 
But when i hover over the 'value' property, the sample is displaying correctly as dd/mm/yyyy.

 
 
 
As you can see in the formula bar, i have tried using Text commands to force it but it still refuses to display as dd/mm/yyyy in the form.
 
Would really appreciate some help!
 
Thank you
 
Shannon
  • MichaelFP Profile Picture
    MichaelFP 1,442 on 26 Nov 2024 at 10:27:18
    Date will not show in the correct format of dd/mm/yyyy
    @SS-11082242-0 you can select the classic control in the list of components. I you will need to remove modern control and add the classic. it is not possible to convert in place.
  • SS-11082242-0 Profile Picture
    SS-11082242-0 17 on 25 Nov 2024 at 23:00:44
    Date will not show in the correct format of dd/mm/yyyy
    Thanks @MichaelFP for your reply. I don't seem to have the Format property available. 
     
    I've tried to add a new date picker box and it the same - no format property, only 'Value'.
     
    Is there a way to revert back to classic mode?
     
    Thanks
    Shannon
  • Verified answer
    MichaelFP Profile Picture
    MichaelFP 1,442 on 20 Nov 2024 at 01:10:35
    Date will not show in the correct format of dd/mm/yyyy
    It is look like that Modern control is not accepting the custom formats in the Format property.
     
    Try to use the classic one it is accepting the custom format.
     
     
    If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as answer ✔️. This is help the community.

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard

Featured topics