Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsTimestamp function |
|
|
| GetAsTimestamp function |
| Format |
GetAsTimestamp(text) |
| Parameter |
| text - any text expression, or text, number, date, or time field |
| Data type returned |
| timestamp |
| Description |
| Returns text as data type timestamp, for use with formulas involving timestamps. Text 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. |
| Examples |
| GetAsTimestamp("4/5/2009 4:05:06") returns 4/5/2009 4:05:06 AM. |
| GetAsTimestamp(50000) returns 1/1/0001 1:53:20 PM. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsTimestamp function |
|
|
Next Page |
|