Format Column or Sequence Value in Numbering Scheme

2/11/2020
Applies To: Number Generator

This article describes how to apply formatting in scheme numbering definition.

Introduction

Vitextra Number Generator allows to automatically generate value for column based on other columns and sequences.

SharePoint Filter Date Time column

Supported Column Types

Number Generator supported the following SharePoint column types:

  • Date and Time
  • Number
  • Counter
  • Integer

Note
Formatting rules are the same for types Number, Counter, and Integer.

Define Formatting

To apply formatting use the syntax:

[DateColumn:format]

DateTime Column Formatting

DateTime formatting can be applied only to Date and Time column type.
Some common values used in format are as follow:

Value Description Value Output
yyyy The year as a four-digit number 4/12/1986 9:15:00 1986
yy The year, from 00 to 99 4/12/1986 9:15:00 86
MM The abbreviated name of the month 4/12/1986 9:15:00 Apr
MMMM The full name of the month 4/12/1986 9:15:00 April
d The day of the month, from 1 through 31 4/2/1986 9:15:00 2
dd The day of the month, from 01 through 31 4/2/1986 9:15:00 02
ddd The abbreviated name of the day of the week 4/12/1986 9:15:00 Sat
dddd The full name of the day of the week 4/12/1986 9:15:00 Saturday
h The hour in AM/PM from 1 to 12 4/12/1986 9:15:00 9
hh The hour in AM/PM from 01 to 12 4/12/1986 9:15:00 09
H The hour in 24-hour from 0 to 23 4/12/1986 9:15:00 9
HH The hour in 24-hour from 00 to 23 4/12/1986 9:15:00 PM 21
m The minute, from 0 through 59 4/12/1986 9:05:00 5
mm The minute, from 00 through 59 4/12/1986 9:05:00 05
tt AM/PM designator 4/12/1986 23:15:00 PM

Column reference and formatting separated by a colon must be in square brackets.

The Created column formatting to use in numbering scheme:

[Created:yyyy-MM-dd]

Output for value equal to 2/10/2020 11:00AM is 2020-02-10.

Note
The culture which is used to format Date value is determined by the site where the list or library located.

Number Column Formatting

Number formatting can be applied to number column types as well as sequences.

The following table describes the numeric format specifiers.

Specifier Description Value Format Output
0 Replaces the zero with the corresponding digit if one is present 235 00000 00235
# Replaces the # symbol with the corresponding digit if one is present 235 ##### 235
. Determines the location of the decimal separator in the result string 23.5 #.00 23.50
, Determines the location of the group separator in the result string 1235 #,# 1,235

Note
0 used to display of insignificant zeros when a number has fewer digits than than zeros in the format otherwise, zero appears in the result string.

See Also

Share