Custom Date and Time Format Strings

BarTender allows you to create custom date and time formatting, which can be be as broad or as granular as you need. To create a custom data type, you can combine any of the following strings, so that the resulting formatting matches your design needs.

The following custom date and time format strings are available when defining a custom data type:

Date Specific Strings

Time Specific Strings

Other Available Strings

Date Specific Strings

Format Specifier

Description

Sample, given the date January 2, 2004

/

The date separator, based on the selected locale

 

d

The day of the month, from 1 through 31

2

dd

The day of the month, from 01 through 31

02

ddd

The abbreviated name of the day of the week

Fri

dddd

The full name of the day of the week

Friday

M

The month, from 1 through 12

1

MM

The month, from 01 through 12

01

MMM

The abbreviated name of the month

Jan

MMMM

The full name of the month

January

y

The year, from 0 to 99

4

yy

The year, from 00 to 99

04

yyy

The year, with a minimum of three digits

2004

yyyy

The year, as a four-digit number

2004

yyyyy

The year, as a five-digit number

02004

Y

The last digit of the year, from 0 to 9

4

YY

The last two digits of the year, from 00 to 99

04

YYY

The last three digits of the year, from 000 to 999

004

j

Julian date, from 1 to 366

2

jjj

Julian date, from 001 to 366

002

g

Period or era (B.C./A.D.)

A.D.

@d

Short date pattern

1/2/2004

@D

Long date pattern

Friday, January 02, 2004

@f

Full date and time pattern, with short time

Friday, January 02, 2004 12:00 AM

@F

Full date and time pattern, with long time

Friday, January 02, 2004 12:00:00 AM

@g

General date and time pattern, with short time

1/2/2004 12:00 AM

@G

General date and time pattern, with long time

1/2/2004 12:00:00 AM

@m

Month and day pattern

January 02

@y

Year and month pattern

January, 2004

@r

RFC1123 pattern

Fri, 02 Jan 2004 18:54:03 GMT

Other Available StringsReturn to Top

Time Specific Strings

Format Specifier

Description

Sample, given the time 6:54:03 PM

:

The time separator, based on the selected locale

 

h

The hour, using a 12-hour clock from 1 to 12

6

hh

The hour, using a 12-hour clock from 01 to 12

06

H

The hour, using a 24-hour clock from 0 to 23

18

HH

The hour, using a 24-hour clock from 00 to 23

18

m

The minute, from 0 to 59

54

mm

The minute, from 00 to 59

54

s

The second, from 0 to 59

3

ss

The second, from 00 to 59

03

f

Tenths of a second

 

ff

Hundredths of a second

 

fff

Thousanths of a second; the millisecond

 

ffff

Ten thousanths of a second

 

fffff

Hundred thousanths of a second

 

ffffff

Millionths of a second; the microsecond

 

fffffff

Ten millionths of a second

 

F

Tenths of a second, with no trailing zeros

 

FF

Hundredths of a second, with no trailing zeros

 

FFF

Thousanths of a second, with no trailing zeros; the millisecond

 

FFFF

Ten thousanths of a second, with no trailing zeros

 

FFFFF

Hundred thousanths of a second, with no trailing zeros

 

FFFFFF

Millionths of a second, with no trailing zeros; the microsecond

 

FFFFFFF

Ten millionths of a second, with no trailing zeros

 

t

The first character of the AM/PM designator

P

tt

The AM/PM designator

PM

@t

Short time pattern

6:54 PM

@T

Long time pattern

6:54:03 PM

@f

Full date and time pattern, with short time

Friday, January 02, 2004 6:54 PM

@F

Full date and time pattern, with long time

Friday, January 02, 2004 6:54:03 PM

@g

General date and time pattern, with short time

1/2/2004 6:54 PM

@G

General date and time pattern, with long time

1/2/2004 6:54:03 PM

@r

RFC1123 pattern

Fri, 02 Jan 2004 18:54:03 GMT

Date Specific StringsReturn to Top

Other Available Strings

Format Specifier

Description

Sample, given the date 1/2/2004 and the time 6:54:03 PM

'literal'

Literal string delimiter

 

\

The escape character. When the escape character is used, BarTender interprets the character immediately following the escape character as a literal character.

 

K

The time zone; returns Z for UTC or an empty value for local time.

Z

z

The number of hours offset from UTC, with no leading zeros

-8

zz

The number of hours offset from UTC, with a leading zero for a single-digit number

-08

zzz

The hours and minutes offset from UTC

-08:00

w

Weekday number, from 0 to 6 (where 0 = Sunday)

5

u

ISO 8601 weekday number, from 1 to 7 (where 1 = Monday)

5

U

Week number, from 0 through 53 (where Sunday is the first day of the week)

0

UU

Week number, from 00 through 53 (where Sunday is the first day of the week)

00

W

Week number, from 0 to 53 (where Monday is the first day of the week)

0

WW

Week number, from 00 to 53 (where Monday is the first day of the week)

00

WWW

Week number, from 1 to 54 (where Monday is the first day of the week)

1

WWWW

Week number, from 01 to 54 (where Monday is the first day of the week)

01

vvvv

ISO 8601 week numbering year

2004

VV

ISO 8601 week number, from 01 to 53

01

Date Specific StringsTime Specific StringsReturn to Top