Difference between revisions of "MDY()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a date as a character string | Function to return a date as a character string | ||
− | |||
==Syntax== | ==Syntax== | ||
MDY(<expD>) | MDY(<expD>) | ||
− | |||
==See Also== | ==See Also== | ||
[[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[EPOCH()]], [[MONTH()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[STOD()]], [[TIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]] | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[EPOCH()]], [[MONTH()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[STOD()]], [[TIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]] | ||
− | |||
==Description== | ==Description== | ||
The MDY() function returns a character string of the form of "Month name Day, Year" from the specified <expD>. If CENTURY is OFF, then a 2-digit year is returned. | The MDY() function returns a character string of the form of "Month name Day, Year" from the specified <expD>. If CENTURY is OFF, then a 2-digit year is returned. | ||
− | |||
==Example== | ==Example== | ||
Line 21: | Line 17: | ||
April 4, 1990 | April 4, 1990 | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 12:58, 11 December 2012
Purpose
Function to return a date as a character string
Syntax
MDY(<expD>)
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), DAY(), DMY(), DOW(), DTOC(), DTOS(), DTOV(), EPOCH(), MONTH(), SET CENTURY, SET DATE, SET EPOCH, STOD(), TIME(), VTOD(), WEEK(), YEAR()
Description
The MDY() function returns a character string of the form of "Month name Day, Year" from the specified <expD>. If CENTURY is OFF, then a 2-digit year is returned.
Example
set century on ? mdy({04/04/1990}) April 4, 1990
Products
Lianja Server, Lianja