• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/DocumentsCorePack: Custom Date and Time Format Strings

DocumentsCorePack: Custom Date and Time Format Strings

1485 views 0 Updated on July 27, 2022

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.
reworkneeded.. reference other datetime articles

Was this helpful?

Yes  No
Related Articles
  • Integrating JSON data into documents
  • Simplify Contract Processes with Dynamics 365 + E-Signature 
  • How to update the metadata in the DocumentsCorePack Template Designer
  • Working with Product Properties in DocumentsCorePack
  • How to work with the Relationship Manager
  • Using virtual tables in DocumentsCorePack
Latest Articles
  • “Undefined”-labels in Chrome 114 and higher
  • Integrating JSON data into documents
  • Generate large documents using the Multipart-feature of DocumentsCorePack 
  • Recap: DynamicsMinds Conference 2023
  • How to automate the E-signature process via Power Automate
Popular Articles
  • DocumentsCorePack Template Designer – Getting Started
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • Step-by-Step: How to configure a One-Click-Action
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Online Service Configuration
Top Rated Articles
  • IMPORTANT information for Dynamics 365 online customers using DocumentsCorePack and/or AttachmentExtractor
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Step-by-Step: How to configure a One-Click-Action
  • “Blocked by Conditional access” error in Azure Active Directory
  • Online Services: Required Application Permissions
Categories
  • *News and General Infos* 52
  • Webinars 36
  • Template Designer(DCP 181
  • DocumentsCorePack(DCP 197
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 62
  • PowerSearch (PS 48
  • ActivityTools (AT 59
  • SmartBar (SB 53
  • GroupCalendar (GC 46
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
  • © 2022 www.mscrm-addons.com. All Rights Reserved.