Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Product codes
TJ083LL/A
Page of 238
206     FileMaker Functions Reference
Timestamp
Format
Timestamp(date;time)
Parameters
date - any calendar date or date 
time - any time value or time field
Data type returned
timestamp
Description
Returns a timestamp containing date as a calendar date and time as a time of day.
The format of the result depends on the date and time formats that were in use when the 
 was created. You can change the date and time formats in the Regional 
Settings Control Panel (Windows 2000), the Date and Time Control Panel (Windows XP), 
or the Date & Time System Preference (Mac OS).
Examples
Timestamp(Date(10;11;2004);Time(9;10;30)) returns 
10/11/2004 9:10:30AM
.
Timestamp(Date(10;11;2004);Time(13;10;30)) returns 
10/11/2004 
1:10:30PM
.
Timestamp(Date(10;11;2004);Time(10;65;5)) returns 
10/11/2004 
11:05:05AM
.
Timestamp(Date(10;35;2004);Time(4;5;6)) returns 
11/4/2004 4:05:06AM
.