• Archive
  • Back to www.mscrm-addons.com
  • Archive
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)

DocumentsCorePack: Custom Date and Time Format Strings

212 views 0

Written by Administrator
December 6, 2013

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

Format specifierDescriptionExamples
“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 characterThe 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.
reworkneeded.. reference other datetime articles

Was this helpful?

Yes  No
Related Articles
  • General Settings – DocumentsCorePack Server Based
  • How to use the Insert-as-Picture-Link-Field-button in Dynamics-365
  • How to use the Insert-as-Picture-Link-Field-button in Dynamics-365
  • Documents generated in Flows cannot be opened
  • How licenses are counted
  • How to setup editable sections in your template (Dynamics 365)
Latest Articles
  • The Local License Manager
  • TemplateImportExport Console Application – DCPIE.exe
  • How to trigger a Microsoft Flow from dialog
  • General Settings – DocumentsCorePack Server Based
  • How to use the Insert-as-Picture-Link-Field-button in Dynamics-365
Popular Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How licenses are counted
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
  • DocumentsCorePack Charts Feature (Dynamics 365)
Top Rated Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Can you save data capacity by moving email content?
  • Step-by-Step: How to configure a One-Click-Action
  • How to set up an email content service
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
Categories
  • *News and General Infos* 44
  • Template Designer(DCP 151
  • DocumentsCorePack(DCP 146
  • TelephoneIntegration (TI 62
  • AttachmentExtractor (AE 47
  • PowerSearch (PS 42
  • ActivityTools (AT 54
  • SmartBar (SB 49
  • GroupCalendar (GC 43
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2020 www.mscrm-addons.com. All Rights Reserved.