AgileApps Support Wiki Pre Release

DATE

From AgileApps Support Wiki
Revision as of 18:50, 4 November 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The DATE function creates a date in the standard date format from a text string representing the day, month and year. You can also optionally include the time with this function.

Syntax
DATE(year, month, day [,hour, minute, second])
Return
Date in the format defined by Date Format
Example

DATE (1988, 3, 7, 3, 22, 45) = '03/07/1988 03:22:45'