Date formatting

Applies to JungleDocs for Office 365.
For a similar tutorial for JungleDocs for SharePoint 2010-2019, click here.

Date formatting is very simple in JungleDocs for Office 365. All you need to know is the right patterns. We call these formats Date and Time String formats. You can use one of the standard ones from the list below, or create your own. In this tutorial, you will learn how to do this.


Date and time formatting strings

A date and time format string defines the text representation of a DateTime or DateTimeOffset value that results from a formatting operation.

These are all the patterns:


Pattern 

MM/dd/yyyy
Result
03/22/2016
  dddd, dd MMMM yyyy Tuesday, 03 March 2016
  dddd, dd MMMM yyyy HH:mm  Tuesday, 03 March 2016 06:30
  dddd, dd MMMM yyyy hh:mm tt  Tuesday, 03 March 2016 06:30 AM
  dddd, dd MMMM yyyy H:mm  Tuesday, 03 March 2016 6:30
  dddd, dd MMMM yyyy h:mm tt  Tuesday, 03 March 2016 6:30 AM
  dddd, dd MMMM yyyy HH:mm:ss Tuesday, 03 March 2016 06:30:07
  MM/dd/yyyy HH:mm 03/22/2016 06:30
  MM/dd/yyyy hh:mm tt 03/22/2016 06:30 AM
  MM/dd/yyyy H:mm 03/22/2016 6:30
  MM/dd/yyyy h:mm tt 03/22/2016  6:30 AM
  MM/dd/yyyy h:mm tt 03/22/2016  6:30 AM
  MM/dd/yyyy h:mm tt 03/22/2016  6:30 AM
  MM/dd/yyyy HH:mm:ss 03/22/2016 06:30:07
  MMMM dd March 22
  MMMM dd March 22
  yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2016-03-22T06:30:07.7199222-04:00
  yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2016-03-22T06:30:07.7199222-04:00
  ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Tue, 22 Mar 2016 06:30:07 GMT
  ddd, dd MMM yyyy HH':'mm':'ss 'GMT' Tue, 22 Mar 2016 06:30:07 GMT
  yyyy'-'MM'-'dd'T'HH':'mm':'ss 2016-03-22T06:30:07
  HH:mm 06:30
  hh:mm tt 06:30 AM
  H:mm 6:30
  h:mm tt 6:30 AM
  HH:mm:ss 06:30:07
  yyyy'-'MM'-'dd HH':'mm':'ss'Z' 2016-03-22 06:30:07Z
  dddd, dd MMMM yyyy HH:mm:ss Tuesday, 22March 2016 06:30:07
  yyyy MMMM 2016 March
     

Building a custom string

You could also opt to build your own date and time string. Here are all the separate characters you can use, and their qualities, when creating your own string.

d Represents the day of the month as a number from 1 through 31. A single-digit day is formatted without a leading zero
dd Represents the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero
ddd Represents the abbreviated name of the day of the week (Mon, Tues, Wed etc)
dddd Represents the full name of the day of the week (Monday, Tuesday etc)
h 12-hour clock hour (e.g. 7)
hh 12-hour clock, with a leading 0 (e.g. 07)
H 24-hour clock hour (e.g. 19)
HH 24-hour clock hour, with a leading 0 (e.g. 19)
m Minutes
mm Minutes with a leading zero
M Month number
MM Month number with leading zero
MMM Abbreviated Month Name (e.g. Dec)
MMMM Full month name (e.g. December)
s Seconds
ss Seconds with leading zero
t Abbreviated AM / PM (e.g. A or P)
tt AM / PM (e.g. AM or PM
y Year, no leading zero (e.g. 2001 would be 1)
yy Year, leading zero (e.g. 2001 would be 01)
yyy Year, (e.g. 2001 would be 2001)
yyyy Year, (e.g. 2001 would be 2001)
K Represents the time zone information of a date and time value (e.g. +05:00)
z With DateTime values, represents the signed offset of the local operating system's time zone from Coordinated Universal Time (UTC), measured in hours. (e.g. +6)
zz Same as above,  but with leading zero (e.g. +06)
zzz With DateTime values, represents the signed offset of the local operating system's time zone from UTC, measured in hours and minutes. (e.g. +06:00)
f Represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value.
ff Represents the two most significant digits of the seconds fraction; that is, it represents the hundredths of a second in a date and time value.
fff Represents the three most significant digits of the seconds fraction; that is, it represents the milliseconds in a date and time value.
ffff Represents the four most significant digits of the seconds fraction; that is, it represents the ten thousandths of a second in a date and time value. 
fffff Represents the five most significant digits of the seconds fraction; that is, it represents the hundred thousandths of a second in a date and time value. 
ffffff Represents the six most significant digits of the seconds fraction; that is, it represents the millionths of a second in a date and time value. 
fffffff Represents the seven most significant digits of the seconds fraction; that is, it represents the ten millionths of a second in a date and time value. 
F Represents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value. Nothing is displayed if the digit is zero.
: Represents the time separator defined in the current DateTimeFormatInfo..::.TimeSeparator property. This separator is used to differentiate hours, minutes, and seconds.
/ Represents the date separator defined in the current DateTimeFormatInfo..::.DateSeparator property. This separator is used to differentiate years, months, and days.
" Represents a quoted string (quotation mark). Displays the literal value of any string between two quotation marks ("). Your application should precede each quotation mark with an escape character (\).
' Represents a quoted string (apostrophe). Displays the literal value of any string between two apostrophe (') characters.
%c Represents the result associated with a c custom format specifier, when the custom date and time format string consists solely of that custom format specifier. 

Example:  

FormatDate(Today; "yyyy") Result 2016 

FormatDate(DocumentDate; "yyyy-MM-dd") Result: 2021-06-18

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us