Reference > Functions reference > Timestamp functions > Timestamp
 

Timestamp

Returns a timestamp containing a date as a calendar date and a time as a time of day.

Format 

Timestamp ( date ; time )

Parameters 

date - any calendar date or date field

time - any time value or time field

Data type returned 

timestamp

Originated in 

FileMaker Pro 7.0

Description 

The format of the result depends on the date and time formats that were in use when the database file was created. You can change the date and time formats in your operating system.

Example 1 

Timestamp ( Date ( 10 ; 11 ; 2019 ) ; Time ( 9 ; 10 ; 30 ) ) returns 10/11/2019 9:10:30 AM.

Example 2 

Timestamp ( Date ( 10 ; 11 ; 2019 ) ; Time ( 13 ; 10 ; 30 ) ) returns 10/11/2019 1:10:30 PM.

Example 3 

Timestamp ( Date ( 10 ; 11 ; 2019 ) ; Time ( 10 ; 65 ; 5 ) ) returns 10/11/2019 11:05:05 AM.

Example 4 

Timestamp ( Date ( 10 ; 35 ; 2019 ) ; Time ( 4 ; 5 ; 6 ) ) returns 11/4/2019 4:05:06 AM.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas