206 FileMaker Functions Reference
Timestamp
Format
Timestamp(date;time)
Parameters
date - any calendar date or date field
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
database file 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.
Commentaires sur ces manuels