mscrm-addons.com - Blog

IMPORTANT INFORMATION

This blog is deprecated since July 2020.The articles below are no longer maintained and might contain outdated information. 
You can find the most acutal and relevenat information in our Knowledge Base at support.mscrm-addons.com

News.mscrm-addons.com Blog

rss

Hello and welcome to our blog! What can we do for you? Are you looking for further technical information or step-by-step instructions to our products? Or would you like to read the latest news on mscrm-addons? Please feel free to browse our blog for detailed information and to share our posts!


DocumentsCorePack: Custom Date and Time Format Strings
On December 6, 2013 in DCP 2013, DocumentsCorePack (DCP) by Jin Yan Jin Yan

The following table shows the different custom date and time format strings for displaying the DATETIME() function for DocumentsCorePack templates (.docx).

 

Format specifier

 Description Examples
"d"

The day of the month, from 1 through 31.

6/1/2009 1:45:30 PM -> 1
6/15/2009 1:45:30 PM -> 15
"dd"

The day of the month, from 01 through 31.

6/1/2009 1:45:30 PM -> 01
6/15/2009 1:45:30 PM -> 15
"ddd"

The abbreviated name of the day of the week.

6/15/2009 1:45:30 PM -> Mon (en-US)
6/15/2009 1:45:30 PM -> Пн (ru-RU)
6/15/2009 1:45:30 PM -> lun. (fr-FR) 
"f" The tenths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 6
6/15/2009 13:45:30.050 -> 0
"ff" The hundredths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 61
6/15/2009 13:45:30.005 -> 00
"fff" The milliseconds in a date and time value.

6/15/2009 13:45:30.617 -> 617
6/15/2009 13:45:30.0005 -> 000
"ffff"

The ten thousandths of a second in a date and time value.

6/15/2009 13:45:30.6175 -> 6175
6/15/2009 13:45:30.00005 -> 0000
"fffff" The hundred thousandths of a second in a date and time value.

6/15/2009 13:45:30.61754 -> 61754
6/15/2009 13:45:30.000005 -> 00000
"ffffff" The millionths of a second in a date and time value.

6/15/2009 13:45:30.617542 -> 617542
6/15/2009 13:45:30.0000005 -> 000000
"fffffff" The ten millionths of a second in a date and time value.

6/15/2009 13:45:30.6175425 -> 6175425
6/15/2009 13:45:30.0001150 -> 0001150
"F" If non-zero, the tenths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 6
6/15/2009 13:45:30.050 -> (no output)
"FF" If non-zero, the hundredths of a second in a date and time value.

6/15/2009 13:45:30.617 -> 61
6/15/2009 13:45:30.005 -> (no output)
"FFF" If non-zero, the milliseconds in a date and time value.

6/15/2009 13:45:30.617 -> 617
6/15/2009 13:45:30.0005 -> (no output)
"FFFF"

If non-zero, the ten thousandths of a second in a date and time value.

6/1/2009 13:45:30.5275 -> 5275
6/15/2009 13:45:30.00005 -> (no output)
"FFFFF" If non-zero, the hundred thousandths of a second in a date and time value.

6/15/2009 13:45:30.61754 -> 61754
6/15/2009 13:45:30.000005 -> (no output)
"FFFFFF" If non-zero, the millionths of a second in a date and time value.

6/15/2009 13:45:30.617542 -> 617542
6/15/2009 13:45:30.0000005 -> (no output)
"FFFFFFF" If non-zero, the ten millionths of a second in a date and time value.

6/15/2009 13:45:30.6175425 -> 6175425
6/15/2009 13:45:30.0001150 -> 000115
"g", "gg" The period or era. 6/15/2009 1:45:30 PM -> A.D.
"h" The hour, using a 12-hour clock from 01 to 12.

6/15/2009 1:45:30 AM -> 1
6/15/2009 1:45:30 PM -> 1
"hh" The hour, using a 12-hour clock from 01 to 12.

6/15/2009 1:45:30 AM -> 01
6/15/2009 1:45:30 PM -> 01
"H" The hour, using a 24-hour clock from 0 to 23.

6/15/2009 1:45:30 AM -> 1
6/15/2009 1:45:30 PM -> 13
"HH" The hour, using a 24-hour clock from 00 to 23.

6/15/2009 1:45:30 AM -> 01
6/15/2009 1:45:30 PM -> 13
"K" Time zone information.

With DateTime values:
6/15/2009 1:45:30 PM, Kind Unspecified -> 6/15/2009 1:45:30 PM, Kind Utc –> Z
6/15/2009 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings)

With DateTimeOffset values:
6/15/2009 1:45:30 AM -07:00 --> -07:00
6/15/2009 8:45:30 AM +00:00 --> +00:00
"m" The minute, from 0 through 59.

6/15/2009 1:09:30 AM -> 9
6/15/2009 1:09:30 PM -> 9
"mm" The minute, from 00 through 59.

6/15/2009 1:09:30 AM -> 09
6/15/2009 1:09:30 PM -> 09
"M" The month, from 1 through 12. 6/15/2009 1:45:30 PM -> 6
"MM" The month, from 01 through 12. 6/15/2009 1:45:30 PM -> 06
"MMM"

The abbreviated name of the month.

6/15/2009 1:45:30 PM -> Jun (en-US)
6/15/2009 1:45:30 PM -> juin (fr-FR)
6/15/2009 1:45:30 PM -> Jun (zu-ZA)
"MMMM" The full name of the month.

6/15/2009 1:45:30 PM -> June (en-US)
6/15/2009 1:45:30 PM -> juni (da-DK)
6/15/2009 1:45:30 PM -> uJuni (zu-ZA)
"s" The second, from 0 through 59. 6/15/2009 1:45:09 PM -> 9
"ss" The second, from 00 through 59. 6/15/2009 1:45:09 PM -> 09
"t" The first character of the AM/PM designator.

6/15/2009 1:45:30 PM -> P (en-US)
6/15/2009 1:45:30 PM -> 午 (ja-JP)
6/15/2009 1:45:30 PM -> (fr-FR)
"tt"

The AM/PM designator.

6/15/2009 1:45:30 PM -> PM (en-US)
6/15/2009 1:45:30 PM -> 午後 (ja-JP)
6/15/2009 1:45:30 PM -> (fr-FR)
"y" The year, from 0 to 99.

1/1/0001 12:00:00 AM -> 1
1/1/0900 12:00:00 AM -> 0
1/1/1900 12:00:00 AM -> 0
6/15/2009 1:45:30 PM -> 9
"yy" The year, from 00 to 99.

1/1/0001 12:00:00 AM -> 01
1/1/0900 12:00:00 AM -> 00
1/1/1900 12:00:00 AM -> 00
6/15/2009 1:45:30 PM -> 09
"yyy"

The year, with a minimum of three digits.

1/1/0001 12:00:00 AM -> 001
1/1/0900 12:00:00 AM -> 900
1/1/1900 12:00:00 AM -> 1900
6/15/2009 1:45:30 PM -> 2009
"yyyy" The year as a four-digit number.

1/1/0001 12:00:00 AM -> 0001
1/1/0900 12:00:00 AM -> 0900
1/1/1900 12:00:00 AM -> 1900
6/15/2009 1:45:30 PM -> 2009
"yyyyy" The year as a five-digit number.

1/1/0001 12:00:00 AM -> 00001
6/15/2009 1:45:30 PM -> 02009
"z"

Hours offset from UTC, with no leading zeros.

 6/15/2009 1:45:30 PM -07:00 -> -7
"zz" Hours offset from UTC, with a leading zero for a single-digit value. 6/15/2009 1:45:30 PM -07:00 -> -07
"zzz" Hours and minutes offset from UTC. 6/15/2009 1:45:30 PM -07:00 -> -07:00
":" The time separator.

6/15/2009 1:45:30 PM -> : (en-US)
6/15/2009 1:45:30 PM -> . (it-IT)
6/15/2009 1:45:30 PM -> : (ja-JP)
"/" The date separator.

6/15/2009 1:45:30 PM -> / (en-US)
6/15/2009 1:45:30 PM -> - (ar-DZ)
6/15/2009 1:45:30 PM -> . (tr-TR)

"string"
'string'

 Literal string delimiter.

6/15/2009 1:45:30 PM ("arr:" h:m t) -> arr: 1:45 P
6/15/2009 1:45:30 PM ('arr:' h:m t) -> arr: 1:45 P
%

Defines the following character as a custom format specifier.

 6/15/2009 1:45:30 PM (%h) -> 1
\ The escape character. 6/15/2009 1:45:30 PM (h \h) -> 1 h
Any other character The character is copied to the result string unchanged. 6/15/2009 1:45:30 AM (arr hh:mm t) -> arr 01:45 A
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  

 

 

 

 

​ 

 

 

 

 

 

 

​

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.



Comments are closed.


9289 Views
Tagged With: 2013, Client, date, datetime, DCP, DocumentsCorePack, template, time

Search

Categories

Tags

Online GC TI license SB XML AT AttachmentExtractor configuration upgrade AutoMerge TelephoneIntegration 365 DocX 2016 button dashboard debug Business Insight PS 2.0 4.0 PowerSearch Client event TelephoneIntegration configuration SP service workflow TI 2011 error DB AppSource RC DCP DCP AE Fun GroupCalendar Dynamics 365 2015 PS ActivityTools template e-Mail setting call update GroupCalendar Dynamics 365 2016 RC 365 SmartBar troubleshooting Server Office 2015 PS Word DocumentsCorePack SB AttachmentExtractor AT SmartBar OnPremise PowerSearch install DocumentsCorePack AE error ActivityTools CTI template number print 2013 SharePoint settingskey Silverlight AM GC RecordCounter e-Signature