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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Date Format Inconsistent
Power Apps
Unanswered

Date Format Inconsistent

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I know some form of this question has been asked to death, but the problem I'm encountering differs in that it's with the data being inputted into Excel (I know I hate it as a data source too.) Just as a bit of background the app is a medical reporting app and there are three pages for each different type of visit. One for Injury where the one of the dates chosen is the Accident date and the other is the completing Date. The other pages are for mental health visits and illness visits, and they use the same completing date selector (or a copy of) and then they use a Visit date (rather than an accident date.) 

 

So here as you can see the date is formatted correctly and should go into excel with dd/mm/yyyy 

However in the excel doc, it switches between which format it puts in the doc, for no apparent reason.

 

I had some trouble uploading the images so I may need to reupload if they didn't work.

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Well I still can't add images but here is the format for the text. Completed_Date_2 is the date selector for this specific page's "form completed date".

     

    Text(Completed_Date_2.SelectedDate,"[$-en-US]dd/mm/yyy","en-GB")

     

    However the dates in the data source column for that and the other date columns (Accident Date & Visit Date) are inconsistent, they swap between dd/mm/yyyy and mm/dd/yyyy.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard