This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Which date and time will be taken into account?
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
HRecordDate (Function)
In french: HDateEnreg
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
// Get the date and time of the last modification
// on the current record
<Result> = HRecordDate([<Data file> [, <Record number>]])
<Result>: Character string
  • Date and time of the last write operation in YYYYMMDDHHmmSS format. The date and time are expressed in UTC format (Universal Time Coordinated).
  • Empty string ("") if an error occurs or if this feature is not supported by the file.
<Data file>: Optional character string
Name of the data file used.
If this name is not specified, HRecordDate will use the last data file used by the last HFSQL function (function starting with "H").
<Record number>: Optional 8-byte integer
Number of the record used.
If this parameter is not specified, HRecordDate will handle the current record.

Which date and time will be taken into account?

The date and time (with one-second accuracy) are taken from the moment HAdd, HModify, HCross, HDelete or any functionality wrote to the data files (automatic modification of data files, import functions, reindexing, implementation of integrity rules, etc.).
Component: wd280hf.dll
Minimum version required
  • Version 10
This page is also available for…
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help