Returns the date of the last update for the index statistics. These statistics have been calculated with
HStatCalculate or
HIndex.
// Calculate statistics about the CustName key from the Customer data file
HStatCalculate(Customer, CustName)
// Find out the date when these statistics were calculated
ResDate = HStatDate()
Info("The statistics performed on the CustName item " + ...
"were calculated on: " + DateToString(ResDate, maskDateSystem))
Syntax
<Result> = HStatDate([<Data file> [, <Key item>]])
<Result>: Character string
- Date of the last update performed on the statistics, in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD the day). The date is returned in UTC format (Universal Time Coordinated).
- Empty string ("") if the statistics have not been calculated.
<Data file>: Optional character string
Name of the data file used. If this name is not specified, HStatDate uses the last data file used by the last HFSQL management function (function starting with "H").
<Key item>: Optional character string
Name of the key item on which the statistics have been calculated. If this name is not specified, HStatDate will use the last key item used by the last HFSQL management function (function starting with "H").
Remarks
- In HFSQL data files, statistics can be calculated on key items only.
- This function is not available when using a database via Remote Access.