Get(CurrentTimestamp)

Returns the current date and time (to the nearest second) according to the system clock.

Format

Get ( CurrentTimestamp )

None

timestamp

7.0

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.
a number	The total number of seconds elapsed since midnight on January 1, 0001

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.

a number

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.