Using date-and-time expressions in names
Information Console enables you to use date-and-time expressions to add the document generation date and time value to the following items:
*File name
*Version
*Folder location to save the file
For example, to set Sales Report followed by the report generation date as a document name, use the following expression:
Sales Report {mm-dd-yy}
On February 28, 2014, the name appears as:
Sales Report 02-28-14
When scheduling a report to run on a recurring basis, adding a date-and-time expression creates unique document, folder, or version names. A user can create date-and-time expressions in either of the following ways:
*Use the date-and-time formats described in Table 3‑2.
*Create custom date-and-time formats based on the symbols described in Table 3‑3 and Table 3‑4. For information about using locale maps to create custom data‑and‑time formats, see Managing Volumes and Users.
Table 3‑2 lists the custom date-and-time format keywords to use and the expression to which each keyword evaluates in a report. This table uses the locale English (USA). Actuate recommends not using General Date, Long Date, Long Time, Medium Time, and Short Time types.
Table 3‑2 Date-and-time expressions
Keyword
Description
Example
Result
General Date
Returns a date and time in the Short Date Long Time format as defined in the Information Console locale map file
{General Date}
01/23/2015
8:53:03 PM
Long Date
Returns a Long Date as defined in the Information Console locale map file
{Long Date}
Tuesday, January 23, 2015
Long Time
Returns a Long Time as defined in the Information Console locale map file
{Long Time}
8:45:00 PM
Medium Date
Returns a date with the month name abbreviated to three letters: dd‑mmm‑yy
{Medium Date}.xls
23-Jan-15.xls
Medium Time
Returns hours and minutes in 12‑hour format, including AM/PM designation (hh:nn AM/PM)
{Medium Time}
8:45 PM
Short Date
Returns a Short Date as defined in the Information Console locale map file
{Short Date}.xls
01-23-2015.xls
Short Time
Returns hours and minutes in 24‑hour format (hh:nn)
{Short Time}
20:45
Table 3‑3 lists the date format symbols to use and the expression to which each symbol evaluates in a report. The examples and results in Table 3‑3 and Table 3‑4 use a .xls file‑name extension for names of document file types. The examples and results without a .xls file‑name extension are version names. A time appears in 24‑hour format unless you use an AM/PM symbol. The symbol for minute is n. The symbol for month is m.
Table 3‑3 Date format symbols
Symbol
Description
Example
Result
c
Returns the Short Date Long Time format as defined in the Information Console locale map file
{c}
01/23/2015 8:53:03PM
d
Returns the day of the month without a leading zero (1‑31)
Day{d}.xls
Day3.xls
dd
Returns the day of the month with a leading zero (01‑31)
Day{dd}.xls
Day03.xls
ddd
Returns the three-letter abbreviation for the weekday
{ddd}.xls
Tue.xls
dddd
Returns the full name of the day of the week
{dddd}
Tuesday
ddddd
Returns the Short Date string as defined in the Information Console locale map file
{ddddd}
01/23/2015
dddddd
Returns the Long Date string as defined in the Information Console locale map file
{dddddd}.xls
Tuesday, January 23, 2015.xls
m
Returns the number of the month without a leading zero
Month{m}.xls
Month1.xls
mm
Returns the number of the month with a leading zero
Month{mm}.xls
Month01.xls
mmm
Returns the three-letter abbreviation for the name of the month
{mmm}.xls
Jan.xls
mmmm
Returns the full name of the month
{mmmm}.xls
January.xls
w
Returns the day of the week as a number, where Sunday = 1, and Saturday = 7
Weekday{w}.xls
Weekday3.xls
ww
Returns the week of the year as a number (1-53)
Week{ww}.xls
Week4.xls
q
Returns the number of the quarter (1‑4)
Quarter{q}.xls
Quarter1.xls
y
Returns the number of the day of the year (1-365)
Day{y}.xls
Day23.xls
yy
Returns the last two digits of the year (00‑99)
Year{yy}.xls
Year15.xls
yyyy
Returns all four digits of the year (1000‑9999)
Year{yyyy}.xls
Year2015.xls
Table 3‑4 lists the time format symbols that you use and the expression that each symbol evaluates in a report.
Table 3‑4 Time format symbols
Symbol
Description
Example
Result
AMPM
Uses the format that is defined in the Actuate Information Console locale map file. The default format is
AM/PM.
{h:n:s AMPM}
8:45:3 PM
AM/PM
Returns AM/am for any hour before noon and PM/pm for any hour after. This symbol is case-sensitive.
{hh:nn:ss am/pm}
{hh:nn:ss AM/PM}
08:45:03 pm
08:45:03 PM
A/P or a/p
Returns A/a for any hour before noon and P/p for any hour after noon. This symbol is case-sensitive.
{h:n:s a/p}
{h:n:s A/P}
8:45:3 p
8:45:3 P
h
Returns the hour of the day without the leading zero (0‑23).
Hour {h}.xls
Hour 9.xls
hh
Returns the hour of the day with a leading zero (00-23).
Hour {hh}.xls
Hour 09.xls
n
Returns the minute without a leading zero (0-59).
Minute {n}.xls
Minute 5.xls
nn
Returns the minute with a leading zero (00-59).
Minute {nn}.xls
Minute 05.xls
s
Returns the number of seconds without a leading zero (0-59).
Second {s}.xls
Second 1.xls
ss
Returns the number of seconds with a leading zero (00-59).
Second {ss}.xls
Second 01.xls
tttt
Uses the format that is defined in the Actuate Information Console locale map file.
{tttt}
8:45:00 PM