Brother International TD-4520TN FBPL Command Reference - Page 184

Now$, Dateadd, Now

Page 184 highlights

ttttt AM/PM am/pm A/P a/p AMPM \ "string" Time as a complete time (including hour, minute, and second). The default time format is h:mm:ss AM/PM. Uppercase AM with any hour before noon; display an uppercase PM with any hour between noon and 11:59 P.M. Lowercase AM with any hour before noon; display a lowercase PM with any hour between noon and 11:59 P.M. Uppercase A with any hour before noon; display an uppercase P with any hour between noon and 11:59 P.M. Lowercase A with any hour before noon; display a lowercase P with any hour between noon and 11:59 P.M. AMPM can be either uppercase or lowercase, but the case of the string displayed matches the string as defined by your system settings. Next character in the format string. String inside the double quotation marks. Number General Number Currency Fixed Standard Percent Scientific Yes/No True/False On/Off Description Number as entered, with no rounding and no commas. Number with a dollar sign, comma (if appropriate), and two digits to the right of the decimal point. Shows negative numbers inside parentheses. Number with at least one digit to the left of the decimal separator and two digits to the right. Does not show comma. Number with at least one digit to the left of the decimal separator and two digits to the right and commas (if appropriate). Multiplies the value by 100 and displays the result with two digits to the right of the decimal point and a percent sign at the end. Standard scientific notation. Any nonzero numeric value is Yes. Zero is No. Any nonzero numeric value is True. Zero is False. Any nonzero numeric value is On. Zero is Off. User-defined number 0 # . % , E- E+ e- e+ ¥ "ABC" Description Digit placeholder. Displays a digit or a zero. Digit placeholder. Displays a digit or nothing. Decimal placeholder. Percent placeholder. Multiplies the expression by 100. Thousand separator. Scientific format. Next character in the format string. String inside the double quotation marks. Different formats for different number values One section only Two section Three sections Description The format expression applies to all values. The first section applies to positive values and zeros; the second applies to negative values. The first section applies to positive values, the second applies to negative values, and the third applies to zeros. See Also NOW$(), DATEADD(), NOW 179

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280

179
ttttt
Time as a complete time (including hour, minute, and second). The default
time format is h:mm:ss AM/PM.
AM/PM
Uppercase AM with any hour before noon; display an uppercase PM with
any hour between noon and 11:59 P.M.
am/pm
Lowercase AM with any hour before noon; display a lowercase PM with any
hour between noon and 11:59 P.M.
A/P
Uppercase A with any hour before noon; display an uppercase P with any
hour between noon and 11:59 P.M.
a/p
Lowercase A with any hour before noon; display a lowercase P with any hour
between noon and 11:59 P.M.
AMPM
AMPM can be either uppercase or lowercase, but the case of the string
displayed matches the string as defined by your system settings.
\
Next character in the format string.
“string”
String inside the double quotation marks.
Number
Description
General
Number
Number as entered, with no rounding and no commas.
Currency
Number with a dollar sign, comma (if appropriate), and two digits to the right
of the decimal point. Shows negative numbers inside parentheses.
Fixed
Number with at least one digit to the left of the decimal separator and two
digits to the right. Does not show comma.
Standard
Number with at least one digit to the left of the decimal separator and two
digits to the right and commas (if appropriate).
Percent
Multiplies the value by 100 and displays the result with two digits to the right
of the decimal point and a percent sign at the end.
Scientific
Standard scientific notation.
Yes/No
Any nonzero numeric value is Yes. Zero is No.
True/False
Any nonzero numeric value is True. Zero is False.
On/Off
Any nonzero numeric value is On. Zero is Off.
User-defined
number
Description
0
Digit placeholder. Displays a digit or a zero.
#
Digit placeholder. Displays a digit or nothing.
.
Decimal placeholder.
%
Percent placeholder. Multiplies the expression by 100.
,
Thousand separator.
E- E+ e- e+
Scientific format.
¥
Next character in the format string.
"ABC"
String inside the double quotation marks.
Different formats
for different
number values
Description
One section
only
The format expression applies to all values.
Two section
The first section applies to positive values and zeros; the second applies to
negative values.
Three
sections
The first section applies to positive values, the second applies to negative
values, and the third applies to zeros.
See Also
NOW$(), DATEADD(), NOW