Syntax

DATE(Input date string[,Date string format])

Description

Returns the current date, formatted according to <Date string format> (optional) or the system regional settings.

Example

DATE(database field, "DD MMMM YYYY") or DATE("19740227", "").

Input date string

Date in "YYYYMMDD" format (Example: 20070206).

Date string format

Enter the output date format. Use the D, M and Y symbols to represent the date.

d

Number of the day, no leading zero

1

dd

Number of the day, with leading zero

01

ddd

Short weekday name

Mon

dddd

Long weekday name

Monday

m

Number of the month, no leading zero

6

mm

Number of the month, with leading zero

06

mmm

Short month name

Jun

mmmm

Long month name

June

yy

Short year notation

01

yyy

Long year notation

2001

%%

A"%" character

%a

Abbreviated weekday name

%A

Full weekday name

%b

Abbreviated month name

%B

Full month name

%c

Shorthand for "%X %x", the locale format for date and time

%d

Day of the month as a decimal number (01-31)

%e

Same as %d but does not print the leading 0 for days 1 through 9 (unlike strftime(), does not print a leading space)

%F

Milliseconds as a decimal number (000-999)

%H

Hour based on a 24-hour clock as a decimal number (00-23)

%I

Hour based on a 12-hour clock as a decimal number (01-12)

%j

Day of the year as a decimal number (001-366)

%m

Month as a decimal number (01-12)

%M

Minute as a decimal number (00-59)

%p

AM/PM designation for the locale

%S

Second as a decimal number (00-59)

%w

Weekday as a decimal number (0-6), where Sunday is 0

%x

Date using the date representation for the locale, including the time zone (produces different results from strftime())

%X

Time using the time representation for the locale (produces different results from strftime())

%y

Year without century (00-99)

%Y

Year with century (such as 1990)

%Z

Time zone name (such as Pacific Daylight Time; produces different results from strftime())

%z

Time zone offset in hours and minutes from GMT (HHMM)