|
If you wish to format a date in Power Apps, there is a nice set of format letters to provide custom output. So using the Text function I can write
Text(myDate, "mmm dd yy")
Or for time I can write
Text(myTime, "hhmm")
Or I can combine them into
Text(myDateTime, "hhmm mmm dd yy")
Why would anyone think to use the same lower case letters for two very distinct fields?
There is actually a work-around, make sure dd comes first in the date. Good luck 'mercans. 
|
|
|
|
|
Because "mm" means minutes, and "mmm" means the three-letter short month name. If you want the two-digit month number, you use "MM".
Custom date and time format strings - .NET | Microsoft Learn[^]
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I wouldn't necessarily assume that Power Apps use the same conventions .NET does.
I've used Power BI just a tiny bit, and I wouldn't assume anything based on any prior knowledge or...dare I say, common sense.
|
|
|
|
|
No, you use lower case "m" for both.
|
|
|
|
|
I thought 'mmm' meant Beer. At least it does when Homer does it.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
I’m begging you for the benefit of everyone, don’t be STUPID.
|
|
|
|
|
Richard MacCutchan wrote:
There is actually a work-around, make sure dd comes first in the date. Good luck 'mercans. Big Grin |
I would make sure dd comes last. yyyy-mm-dd is my default format.
|
|
|
|
|
|
Richard MacCutchan wrote: Why would anyone think to use the same lower case letters for two very distinct fields?
Maybe they really like Campbell’s Soup?
Their slogan used to be Mmm Mmm Good.
Jeremy Falcon
|
|
|
|
|
I tried to make a struct with two fields named mm and mmm respectively. The compiler accepted it without any warning. Confusing, isn't it? 
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
What if they need the minutes, then the three letter month, then the minutes again, then the two digit numeric month?
We won't ask why, but hypothetically speaking...
|
|
|
|
|
Doesn't PowerApps know whether it is formatting a time object or a date object? That would surprise me a lot.
If I were to develop a formatting function, and was told "No no - you can't use that character to indicate a certain formatting - it has been used to format a very distinct field in a another value type", then I would scream out in protest. I cannot let the format strings for "my" type be limited by the format strings for all other types!
That being said: Doing detail formatting of times and dates is blatant anti-internationalization, an explicit effort to make it difficult to adapt you solution to other markets, an invitation for customers outside your own locale to misunderstand or not understand the data you output. Don't do that! Use locale dependent formatting, and stop fiddling around with literal format strings!
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
Not for the compiler.
|
|
|
|
|
Richard MacCutchan wrote: Why would anyone think to use the same lower case letters for two very distinct fields?
History?
Following has 'd' and 'D'. And 'c' and 'C'.
Formatting Calendar Time (The GNU C Library)[^]
Then there is "C Programming Language 2 edition" copyright 1988 which uses 'm' for minute and 'M' for month. And others.
|
|
|
|
|
Wait...
Is today 10/5 or 5/10?
"In testa che avete, Signor di Ceprano?"
-- Rigoletto
|
|
|
|
|
It's both of course.
|
|
|
|
|
I always use
yyyy-MM-dd
or
dd MMM yyyy
and always include timezones with times.
Multiple hemispheres/countries/etc
|
|
|
|
|
Fine, but if you read my post you will see that "MM" or "MMM" are not valid format specifiers.
|
|
|
|
|
Forget about all format specifiers and use locale dependent formatting.
Forcing your own locale formatting down the throat of customers in other locales is a bad thing to do.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
I didn't say it was a good thing. I was merely pointing out how having to use the same letter for two different fields is a rather bad design choice.
|
|
|
|
|
My father often modified proverbs, just for fun.
His favorite:
"... two birds at hand are worth one in the bush..."
Since I inherited similar life outlook, here is mine , as an outcome of recent discussions.
" you can instruct them to read the rules, then you have something
to brag about if they actually do"
Since I used "inheritance " I hope readers will not label this post as programming post.
|
|
|
|
|
I'm gonna be that guy, because I know it's gonna come up sooner rather than later anyway:
Don't quit your daytime job to start a career in comedy.
Don't look at it as me trying to put you down. Look at it as free advice. I'm doing you a favor. Whether you want to see it that way or not.
|
|
|
|
|
Another modified one:
If what you have to say is not more beautiful than silence... Shut the fvck up!
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
May I suggest to induce the behavior you prefer merely do not post a message. Sooner or later the message will be received.
|
|
|
|
|
I'm a massive fan of butchered sayings... like Biff from Star Trek.
Make like a tree- and get outta here.
My father, mad at my brother, let fly with, "IF THE SHOE FITS, THEN DON'T SAY ANYTHING STUPID!"
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
