Wasp WaspLabeler +2D Manuel d'utilisateur télécharger pdf (Page 134)

130

Wasp Labeler User Manual

Custom Date and Time Formatting (DATEFORMAT Command)

Labeler always stores date as DateTime format. This means that if you have a column in your data that

is just a date, Labeler will add the default time of 12:00:00 AM to it. If you do not want to show the time

on your label, use the DATEFORMAT function described below.

DATEFORMAT Characters and Definitions

Example DATEFORMAT Expressions

DATEFORMAT Characters and Definitions

Character

Definition

Additional Information

Result

Day of the

Month

The day of the month, from 1 through 31.

9/26/2011

1:33:45 = 26

9/1/2011

1:33:45 = 1

Day of the

Month

The day of the month, from 01 through 31.

9/26/2011

1:33:45 = 26

9/1/2011

1:33:45 = 01

ddd

Abbreviated

Day of

Week

The abbreviated day of the week.

9/26/2011

1:33:45 = Mon

dddd

Full Day of

Week

The full name of the day of the week.

9/26/2011

1:33:45 =

Monday

g or gg

Period or

Era

The period or era (A.D.)

9/26/2011

1:33:45 = A.D.

Hour The hour using a 12-hour clock from 1 to 12.

9/26/2011

1:33:45 AM = 1

9/26/2011

1:33:45 PM = 1

Hour The hour using a 12-hour clock from 01 to 12.

9/26/2011

1:33:45 AM =

9/26/2011

1:33:45 PM = 01

Hour The hour using a 24-hour lock from 0 to 23.

9/26/2011

1:33:45 AM = 1

9/26/2011

1 2 ... 129 130 131 132 133 134 135 136 137 138 139 ... 204 205

Commentaires sur ces manuels

Pas de commentaire

Wasp WaspLabeler +2D Manuel d'utilisateur Page 134

Commentaires sur ces manuels