Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 12

  

|

  Text functions     169

Returns times or timestamps in text as data type time, for use with 

the Time or Timestamp functions. The format of the supplied time must be the same as 

the time format on the system where the file was created.
Use the GetAsTime or the Time function to enter a time constant into a formula.

GetAsTime(“02:47:35”) returns 

 when you select time as the calculation 

result. You can perform time calculations on this result.

GetAsTime(“02:47:35”) returns 

 

 when you select timestamp as the 

calculation result.

Abs(GetAsTime(“12:15 pm”) - CheckOut) returns 

 when the CheckOut 

time field contains 3:15 PM.

GetAsTimestamp(text)

text - any 

, or text, number, date, or time 

timestamp

Returns text as data type timestamp, for use with 

strings must be in the form of a date followed by a time. A number is considered to be the 
number of seconds since 1/1/0001. There are 86400 seconds in each day.

GetAsTimestamp(“4/5/2005 4:05:06”) returns 

.

GetAsTimestamp(50000) returns 

.

GetAsURLEncoded(text)

text

 - any