DATE

Syntax: string = DATE
string = DATE('format')

The DATE function can have one argument or no arguments. If no argument is given, it returns a string which contains the current date with the format dd/mm/yyyy. A format argument can be provided, as shown in the table below. The seperator used in the format will be used in the output string.

specifierdisplays
d Displays the day as a number without a leading zero (1-31)
dd Displays the day as a number with a leading zero (01-31)
ddd Displays the day as an abbreviation (Sun-Sat)
dddd Displays the day as a full name (Sunday-Saturday)
m Displays the month as a number without a leading zero (1-12)
mm Displays the month as a number with a leading zero (01-12)
mmm Displays the month as an abbreviation (Jan-Dec)
mmmm Displays the month as a full name (January-December)
yy Displays the year as a two-digit number (00-99)
yyyy Displays the year as a four-digit number (0000-9999)

Examples

function result
DATE  23/05/2002
DATE('mmmm d yyyy')  May 23 2002
DATE('dd-mm-yy')  23-05-02

  String manipulation functions
  TIME