Support Center

Scheduled Report Output File Name Placeholders

The Output File Name can optionally contain placeholders to insert date/time values when the report job is run. If required, this feature enables the report Output File Name to be unique and relevant to the content generated.

The supported placeholders are:

{DateTime:pattern} The date time the report was generated (UTC time zone)
{FromDateTime:pattern} The beginning of the rolling date time window for this report schedule (UTC time zone). A new report schedule will have a default FromDateTime of 1900-01-01 00:00:00. The subsequent runs will use the ToDateTime of the last completed run
{ToDateTime:pattern} The end of the rolling date time window for this report schedule which is always the time the report job was created (UTC time zone)

Example Output File Name with Placeholders:

audit-{DateTime:yyyy}-{FromDateTime:MM-dd-HH-mm-ss}-{ToDateTime:yyyy-MM-dd-HH-mm-ss}.xml

resultant file name:

audit-2016-01-01-00-00-00-2016-08-28-12-28-30.xml

 

The placeholders must contain a date and time formatting pattern based on the following examples:

Pattern Result
   
MM/dd/yyyy 08/28/2016
yyyy-MM-dd 2016-08-28
dddd, dd MMMM yyyy Thursday, 28 August 2016
dddd, dd MMMM yyyy HH:mm Thursday, 28 August 2016 12:28
dddd, dd MMMM yyyy hh:mm tt Thursday, 28 August 2016 12:28 PM
dddd, dd MMMM yyyy H:mm Thursday, 28 August 2016 12:28
dddd, dd MMMM yyyy h:mm tt Thursday, 28 August 2016 12:28 PM
dddd, dd MMMM yyyy HH:mm:ss Thursday, 28 August 2016 12:28:30
MM/dd/yyyy HH:mm 08/28/2016 12:28
MM/dd/yyyy hh:mm tt 08/28/2016 12:28 PM
MM/dd/yyyy H:mm 08/28/2016 12:28
MM/dd/yyyy h:mm tt 08/28/2016 12:28 PM
yyyy-MM-dd HH:mm 2016-08-28 12:28
yyyy-MM-dd hh:mm tt 2016-08-28 12:28 PM
yyyy-MM-dd H:mm 2016-08-28 12:28
yyyy-MM-dd h:mm tt 2016-08-28 12:28 PM
MM/dd/yyyy HH:mm:ss 08/28/2016 12:28:30
yyyy-MM-dd HH:mm:ss 2016-08-28 12:28:30
MMMM dd August 28
MMMM yyyy August 2016
yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2016-08-28T12:28:30.0000000
yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK 2016-08-28T12:28:30.0000000
ddd, dd MMM yyyy HH':'mm':'ss 'GMT   Thu, 28 Aug 2016 12:28:30 GMT
ddd, dd MMM yyyy HH':'mm':'ss 'GMT Thu, 28 Aug 2016 12:28:30 GMT
yyyy'-'MM'-'dd'T'HH':'mm':'ss 2016-08-28T12:28:30
HH:mm 12:28
hh:mm tt 12:28 PM
H:mm 12:28
h:mm tt 12:28 PM
HH:mm:ss 12:28:30
yyyy'-'MM'-'dd HH':'mm':'ss'Z 2016-08-28 12:28:30Z
dddd, dd MMMM yyyy HH:mm:ss Thursday, 28 August 2016 12:28:30
yyyy MMMM 2016 August
   

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk