El DateStr

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Returns an 8-character numerical string corresponding to the specified date. The string is in the yyyyMMdd format, where yyyy is the four-digit year, MM is the month, and dd is the day of the month.

Usage

El_DateStr(dd, MM, yyyy)

Where:

dd - a numerical expression specifying the day of the month.

MM - a numerical expression specifying the month.

yyyy - a four-digit numerical expression specifying the year.

Notes

To have more control about the formatting of a date string, use FormatDate.
Use StringToDate to convert a date string to a numerical date value.

Example

El_DateStr(02, 04, 2008)

Will return the string "20080402", corresponding to the specified date of April 2nd, 2008.