Get(CurrentTimestamp)

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

Format 

Get ( CurrentTimestamp )

Parameters 

None

Data type returned 

timestamp

Originated in version 

7.0

Description 

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

Notes 

  • 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.

Example 1 

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.