@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])