Friendly date format

(0) Share

Report

Posted on by SumanthDundi7

219

Hi,

Can you please help me how to show date field value in this format as below?

July 18,2022.

Currently I am using .LongDate logic but it is showing me like Monday, July 18,2022. I dont need to show Monday but just July 18,2022.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

RusselThomas 4,014 on at

Like (0)

Report
Copy link

Link copied!
Hi @SumanthDundi7
Text(Today(), "mmmm dd,yyyy")
Obviously replace Today() with whatever your datevalue input is...
Hope this helps,
RT

Was this reply helpful? Yes No
SumanthDundi7 219 on at

Like (0)

Report
Copy link

Link copied!

Hi @RusselThomas , Thank you.
But I would need to do it on a date field itself.

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like (0)

Report
Copy link

Link copied!

hi @SumanthDundi7 ,
Can you be more specific then please - What control are you using, which property, and what is your current expression/code on this property?
Kind regards
RT

Was this reply helpful? Yes No
SumanthDundi7 219 on at

Like (0)

Report
Copy link

Link copied!

Okay @RusselThomas . I am using a formula for work scheduler App to show all next weeks dates as in the below screenshot. In the default property of Monday date field type I am using the formula as below.

DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday)+7,Days)

And for Tuesday till Sunday I am adding +1,+2 etc using DateAdd formula.

Thank you

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like (0)

Report
Copy link

Link copied!
Hi @SumanthDundi7
Ok, so your date input value is

DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday)+7,Days)

So your final expression is

Text(DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday)+7,Days), "mmmm dd,yyyy")

Remember that as soon as you display a date in a text control like a label, it gets typed to text anyway. The data itself might be a date type, but to display, it will get retyped to Text. This shouldn't affect your app as you shouldn't necessarily be using the text label as your date source. If you are, then you'll have to type it back using DateValue() - but for display purposes, the above example should suit your needs.
Kind regards,
Russel

Was this reply helpful? Yes No