@Date (Formula Language)

Translates numbers for the various components of time and date, then returns the time-date value.

Syntax

@Date( year ; month ; day ) @Date( year ; month ; day ; hour ; minute ; second ) @Date( time-date )

Parameters

year

Number. The year that you want to appear in the resulting date. You must specify an entire four-digit year. (For example, use 1996, not 96).

month

Number. The month that you want to appear in the resulting date. (For example, use 1 to specify January).

day

Number. The day that you want to appear in the resulting date.

hour

Number. The number of hours. This value will be truncated from the resulting date.

minute

Number. The number of minutes. This value will be truncated from the resulting date.

second

Number. The number of seconds. This value will be truncated from the resulting date.

time-date

Time-date or time-date list. For a time-date value such as @Now or [10/31/93 12:00:00], @Date removes the time portion of the value, leaving only the date.

Return value

truncatedTimeDate

Time-date. The date corresponding to the parameters that you sent to @Date, minus any time components.

Usage

If the parameter is a date-time list, the function operates on each element of the list, and the return value is a list with the same number of elements.

Specifying invalid numbers will result in a blank date.

Examples

This example returns 06/23/95.
```
@Date(1995; 06; 23)
```
This example returns 06/23/0095.
```
@Date(95; 06; 23)
```
This example returns 06/23/2095.
```
@Date(2095; 06; 23)
```
This example returns 06/23/95 if the time-date value in the field named ResponseDate is 06/23/95 03:00:01 P.M.
```
@Date(ResponseDate)
```
This example returns 1/20/93 08:58:12 AM.
```
@Date(1993; 01; 20; 8; 58; 12)
```
This example returns 11/20/95.
```
@Date([11/20/95 8:58:12])
```
This example returns 11/20/95 and 11/21/95 in a list.
```
@Date([11/20/95 8:58:12] : [11/21/95 8:58:12])
```