@TimeToTextInZone (Formula Language)

Converts a time-date value to a text string, incorporating time zone information.

Syntax

@TimeToTextInZone( timeDate ; timeZone ; formatString )

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.

string

The time-date value converted to a string.

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.

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")
```