Running jobs : Using date-and-time expressions in names
 
Using date-and-time expressions in names
Information Console supports date-and-time expressions to automatically add the document generation date and time value to the:
*File name
*Version of the file
*Directory name where the file will be saved
For example, to display Sales Report followed by the report generation date as a document name, use the following expression:
Sales Report {mm-dd-yy}
On August 28, 2011, the name appears as:
Sales Report 08-28-11
When scheduling a report to run on a recurring basis, adding a date-and-time expression creates unique document, directory, or version names. A user can create date-and-time expressions in either of the following ways:
*Use the date-and-time formats in Table 3‑6.
*Create custom date-and-time formats based on the symbols in Table 3‑7 and Table 3‑8.
Table 3‑6 lists the 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‑6 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/2011
8:53:03PM
Long Date
Returns a Long Date as defined in the Information Console locale map file
{Long Date}
Tuesday, January 23, 2011
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-11.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-2011.xls
Short Time
Returns hours and minutes in 24‑hour format (hh:nn)
{Short Time}
20:45
Table 3‑7 lists the date format symbols to use and the expression to which each symbol evaluates in a report.
Table 3‑7 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/2011 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/2011
dddddd
Returns the Long Date string as defined in the Information Console locale map file
{dddddd}.xls
Tuesday, January 23, 2011.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
Year11.xls
yyyy
Returns all four digits of the year (1000‑9999)
Year{yyyy}.xls
Year2011.xls
Examples and results with a .xls file-name extension are document names. Examples and results without a .xls file-name extension are version names.
Table 3‑8 lists the time format symbols that you use and the expression that each symbol evaluates in a report. The examples and results 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.
Table 3‑8 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
Times return in 24-hour format unless you use an AM/PM symbol. The symbol for minute is n. The symbol for month is m.