Timestamp
 
Purpose 
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.
Examples 
Timestamp(Date(10;11;2014);Time(9;10;30)) returns 10/11/2014 9:10:30 AM.
Timestamp(Date(10;11;2014);Time(13;10;30)) returns 10/11/2014 1:10:30 PM.
Timestamp(Date(10;11;2014);Time(10;65;5)) returns 10/11/2014 11:05:05 AM.
Timestamp(Date(10;35;2014);Time(4;5;6)) returns 11/4/2014 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
Was this topic helpful? Send feedback.