FILEDATE - Get the date of a file (Reports & Settings Report Generator function)

Syntax

$FILEDATE{filepath, N/T, CCYYMMDD}

Description

Given a string containing a file name with path information, will return just the date this file was last modified.

Parameters

filepath

A text parameter that can not be omitted.

The path and filename of the file.

N/T

A text parameter that can be omitted (it defaults to "N").

N

Numeric result. This is the number of days since the first of January 1980. This is most commonly used for sorting purposes.

T

Text result. This is the date formatted for display, e.g. '01/01/2004'. You can optionally use the next parameter to control the exact format.

CCYYMMDD

A text parameter that can be omitted (it defaults to "DD/MM/CCYY").

When the previous parameter is 'T', this parameter can be used to control the exact format. The following four values can be combined in any order, with separating characters if required.

DD

Day (01 to 31).

MM

Month (01 to 12).

CC

Century (19 or 20).

YY

Year (00 to 99).

DD/MM/CCYY Same as the default. MM/DD/CCYY Output in USA format. CCYYMMDD Use for sorting into date order (would have the same effect as using the numeric result). CCYYMM Use for grouping by month.

Returns

A numeric value. The date that this file was last modified. This can then be used with the $DATE function to produce a formatted date.