Returns the current date and time (to the nearest second) according to the system clock.
Get ( CurrentTimestamp )
Data type returned
Originated in version
The data type of a calculation result determines how the returned value of this function is represented.
If the calculation result is
This function returns
timestamp or text
The current date and time in the format determined by the operating system settings when the file was created
Note If the number of seconds is zero, seconds are not included—for example, 1/1/2019 11:30 AM.
The total number of seconds elapsed since midnight on January 1, 0001
- In client-server and peer-to-peer environments, this function returns the time and date on the client machine. To get the host machine's date and time, use the Get(CurrentHostTimestamp) function.
Returns 1/1/2019 11:30:01 AM when the calculation result is text and the system clock shows January 1, 2019 11:30:01.