@TimeToTextInZone (Formula Language)
Converts a time-date value to a text string, incorporating time zone information.
Syntax
@TimeToTextInZone( timeDate ; timeZone ; formatString )
Parameters
timeDate
Time-date value or time-date list. The time-date value or values to be converted.
timeZone
Canonical time zone value. You can derive a time zone value using a Notes® Time zone field.
formatString
Optional. String consisting of one or more of the following format specifiers:
| Format specifier | Definition |
|---|---|
| D0 | Year, month, and day |
| D1 | Month and day, year if it is not the current year |
| D2 | Month and day |
| D3 | Month and year |
| T0 | Hour, minute, and second |
| T1 | Hour and minute |
| S0 | Date only |
| S1 | Time only |
| S2 | Date and time |
| S3 | Date, time, Today, or Yesterday |
| Sx | Use when you cannot predict the exact format of the value being passed, but you know that it is either a time, a date, or both. |
You can include up to three specifiers, but only one that begins with D, one that begins with T, and one that begins with S.
Return value
string
The time-date value converted to a string.
Usage
If the first parameter is a list, the function operates on each list element, and the return value is a list with the same number of elements.
Examples
- This code, when used in an action button on a form, applies the zone information of GMT-00:00 that a user selects from the list in the "There" Time zone field to the time-date of 02/26/2002 03:19 PM EST that results from an @Now formula in the "Here" Date/Time field. The "Time there" message box that appears displays "02/26/2002 08:19:00 PM."
@Prompt([OK];"Time there";@TimeToTextInZone(Here;There))
- This code, when added as a Column Value formula, displays "11:06 AM Today" in the view column if the Here field contains "02/26/2002 03:06 PM EST," the There field contains Z=9$DO=1$DL=4 1 1 10-1 1$ZX=3$ZN=Alaskan (which displays as GMT -09:00 Alaska), and the current date is 02/26/2002.
@TimeToTextInZone(Here;There;"D2T1S3")