.NODE

Timestamp()

Category: Timestamp

Syntax: Timestamp ( date; time )


Parameters:

dateAny calendar date or expression that returns a date. The date parameter can also be an integer from 1 to 1460970, representing the number of days since January 1, 0001.

timeAny time value or expression that returns a time value. The time parameter can also be an integer representing the number of seconds since midnight.

Data type returned: Timestamp

Description:

Returns a timestamp from the two parameters in the format "12/12/2005 10:45:00 AM".

You can use text parsing functions or mathematical operations to extract the pieces of a timestamp. You can also use the GetAsDate() and GetAsTime() functions to retrieve just the date or time.

Internally, FileMaker Pro stores timestamp data as the number of seconds since 1/1/0001 12:00 a.m. You can use the GetAsNumber() function to see the numeric representation. For instance, GetAsNumber (Timestamp ("4/18/2004"; 12:00pm)) returns 63217886400.

You can manually calculate the integer value of a timestamp by using the following formula:

 (GetAsNumber (myDate)-1) * 86400 + GetAsNumber (myTime)


Examples:

Function

Results

Timestamp ("10/11/2005"; "10:20 AM")

Returns 10/11/2005 10:20 AM.

Timestamp ("10/11/2005"; "20:20:20")

Returns 10/11/2005 8:20:20 PM.

Timestamp (Date (10;11;2005); Time (10;20;00))

Returns 10/11/2005 10:20 AM.

Timestamp (laborDay; 0)

Returns 9/5/2005 12:00:00 AM when laborDay is equal to 9/5/2005.

Timestamp (1; 0)

Returns 1/1/0001 12:00 AM.




: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

show all menu





FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net