Convert a date to a character month name

     CMONTH(<dDate>) --> cMonth


     <dDate> is the date value to convert.


     CMONTH() returns the name of the month as a character string from a date
     value with the first letter uppercase and the rest of the string
     lowercase.  For a null date value, CMONTH() returns a null string ("").


     CMONTH() is a date conversion function useful for creating formatted
     date strings that can be used in reports, labels, or screens.


     .  These examples illustrate CMONTH():

        ? CMONTH(DATE())                     // Result: September
        ? CMONTH(DATE() + 45)                // Result: October
        ? CMONTH(CTOD("12/01/94"))           // Result: December
        ? SUBSTR(CMONTH(DATE()), 1, 3) +;
           STR(DAY(DATE()))                  // Result: Sep 1

 Files   Library is CLIPPER.LIB.

See Also: CDOW() DATE() DAY() MONTH() YEAR()


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.