TeamDesk Knowledge Base & Support

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.