Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
New Date Format request
Current choices for Date Format are:

Short Date - 5/12/2015
Long Date - Saturday, 5th December 2015
Month Day - December 5th
Year Month - December 2015

I'd like Month Day Year please...to look like:
5th December 2015

Thank you 😃
ID
876
Category
TeamDesk
Author

basenine
Date Created
6/23/2015 5:54:04 AM
Date Updated
9/16/2016 4:24:41 AM
Status
New Idea
Score
30
Promoted By
Francis Lammartin oliverbasenine
Comments
basenine 6/23/2015 6:04:08 AM
and cobbling together a formula:
Format([Date],"dd MMMM yyyy")

whilst effective, is long winded and now justifies the date to the Left rather than the right...

Just sayin'!
Kirill Bondar  Staff  6/23/2015 7:44:09 AM
Indeed, via Format() function you can construct any format from individual parts, but this approach is not culture-invariant since the order of days/months and years varies from culture to culture. It goes even worth for cultures requiring month name to be in genitive case for such a date representation.

"Long date" format we provide relies on .NET's standard date formatting pattern which includes date name and unfortunately there is no pattern with shorter representations that include month name.


basenine 6/23/2015 8:08:02 AM
https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx

Shows the list of usable formats with the .net framework.

dd MMMM yyyy seems to be possible:

DateTime thisDate1 = new DateTime(2011, 6, 10);
Console.WriteLine("Today is " + thisDate1.ToString("MMMM dd, yyyy") + ".");

DateTimeOffset thisDate2 = new DateTimeOffset(2011, 6, 10, 15, 24, 16,
TimeSpan.Zero);
Console.WriteLine("The current date and time: {0:MM/dd/yy H:mm:ss zzz}",
thisDate2);
// The example displays the following output:
// Today is June 10, 2011.
// The current date and time: 06/10/11 15:24:16 +00:00
Kirill Bondar  Staff  6/23/2015 9:48:48 AM
"MMMM dd, yyyy" or "dd MMMM yyyy"? :) And how to display "1st" or "5th"?
basenine 6/23/2015 4:50:05 PM
This is just an example of one type...whereby it's shorter than long date with a representation that includes month name
Following criterion are displayed below the example in that link. BTW, in the help pages, this link is referenced for extra combinations of output formats 😉

I guess I'm confused that you mentioned that TD uses the .net framework and that
(dd MMMM yyyy) is not supported

I'm not sure what you mean by 1st and 5th 😜
Kirill Bondar  Staff  6/24/2015 5:11:06 AM
Speaking of .NET, there are two types for format strings:

Standard: https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx
Custom: https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx

The advantage of standard formats is that they produces culture specific output. For example, short date standard pattern "d" translates to "dd/MM/yyyy" for English UK, but for English US it would be "MM/dd/yyyy". Rules for each culture and embedded in .NET.

There is short date pattern "d" which includes numbers only.
There is long date pattern "D" which includes the day of week.
Unfortunately there is nothing in-between.

That's what I meant with "MMMM dd, yyyy or dd MMMM yyyy?". Once you construct format string from individual parts you stick to a certain output pattern **you** would like to see. I agree, "day month-name year" pattern will be recognized in most of world cultures, but what about some exotic ones like Telugu or Dhivehi?

basenine 6/24/2015 5:34:48 AM
God bless Telugu or Dhivehi....

They've been holding us back for years now!
😉

Francis Lam 9/16/2016 4:24:41 AM
Any chance to have something in between a Short Date and Long Date, for example dd-mmm-yyyy (01-Oct-2016) or mmm-dd-yyyy (Oct-01-2016). This will not be too long as a field and is clear to everyone regarding the date and month.


Feedback
 
Back to Search Results