cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Date Format issue

I need to generate a date in the following format:  August 25, 2019

My date field comes from a database in the following format: 8/25/2019

The LongDate format in PowerApps adds the day of the week:  Sunday, August 28, 2019

The ShortDate returns: 8/25/2019

 

How can I get the result I need?

Thanks

Ron

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User II
Dual Super User II

Re: Date Format issue

YOu can use the Text() function and the following date format string.

Text(DatePicker1.SelectedDate,"mmmm dd, yyyy")


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Highlighted
Dual Super User II
Dual Super User II

Re: Date Format issue

YOu can use the Text() function and the following date format string.

Text(DatePicker1.SelectedDate,"mmmm dd, yyyy")


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,001)