Filemaker Pro 8.5 Advanced Maintenance TG761Z/A Manual Do Utilizador
Códigos do produto
TG761Z/A
Chapter 12
|
Text functions 169
Description
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.
Use the GetAsTime or the Time function to enter a time constant into a formula.
Examples
GetAsTime(“02:47:35”) returns
2:47:35
when you select time as the calculation
result. You can perform time calculations on this result.
GetAsTime(“02:47:35”) returns
1/1/0001
2:47:35
when you select timestamp as the
calculation result.
Abs(GetAsTime(“12:15 pm”) - CheckOut) returns
3:00:00
when the CheckOut
time field contains 3:15 PM.
GetAsTimestamp
Format
GetAsTimestamp(text)
Parameter
text - any
, or text, number, date, or time
Data type returned
timestamp
Description
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.
number of seconds since 1/1/0001. There are 86400 seconds in each day.
Examples
GetAsTimestamp(“4/5/2005 4:05:06”) returns
4/5/2005 4:05:06 AM
.
GetAsTimestamp(50000) returns
1/1/0001 1:53:20 PM
.
GetAsURLEncoded
Format
GetAsURLEncoded(text)
Parameter
text
- any