Tag Archives: MDY

DMY()

Posted on by vivaclipper

DMY()

Returns the date as a string in DD Month YY format

Syntax

       DMY([<dDate>], [<lMode>]) --> cDate

Arguments

<dDate> Designates the date from which to create a string. The default is the system date.

<lMode> Designates whether to insert a period (.) after the day (see Examples). The default is no period (.F.).

Returns

DMY() returns a character string in “DD[.] Month YY” format or “DD[.] Month YYYY” format.

Description

Use DMY() to return the date as a character string using the day, name of month, and year. The SET CENTURY ON/OFF switch determines whether or not the year is displayed in two or four digits. If the <lMode> parameter is designated .T., the function builds in a “.” after the day designation. If no date is designated as a parameter, the function automatically uses the current system date.

Note

. The month name returned depends on which CA-Clipper nations module is in use.

Examples

       .  Display the system date (1/1/89):
              SET CENTURY OFF
              ? DMY()                            // 1 January 89
           .  With ".":
              ? DMY(.T.)                         // 1. January 89
           .  Display a different date:
              SET CENTURY ON
              ? DMY(CTOD("02/01/89"), .T.)       // 1. February 1989

Compliance

DMY() is compatible with CT3’s DMY().

Platforms

All

Files

Source is dattime2.prg, library is libct.

See also

MDY()

Date & Time Functions

Posted on by vivaclipper

Date & Time Functions

ADays Returns an array with the days names
AddMonth Adds or subtracts months to/from a date
AMonths Returns an array with the months names
BOM Beginning date Of Month of given date
BOQ Date of beginning Of quarter containing given date
BOY Date to find first day of year, default is DATE()
CDoW Converts a date to the day of week
CMonth Return the name of the month
CToD Converts a character string to a date expression
CToDoW Convert name of day of the week to its ordinal number
CToMonth Convert name of month to its ordinal number
Date Return the Current OS Date
Day Return the numeric day of the month
Days Convert elapsed seconds into days
DaysInMonth Returns the number of days in month
DaysToMonth Total number of days from first of Jan to beginning of nMonth
DMY Returns the date as a string in DD Month YY format
DoW Value for the day of week
DOY Determines the day of the year for a specific date
DToC Date to character conversion
DToS Date to string conversion
ElapTime Calculates elapted time
EOM End Of Month
EOQ Date of end of quarter
EOY Last date Of Year
IsLeap Tests if a specific year is a leap year
IsLeapYear Checks if the given date is a leap year
LastDayOM Determines the number of days in a month
MDY Returns the date as a string in Month DD, YY or Month DD, YYYY
Month Converts a date expression to a month value
NToCDoW Find day name by num of day
NToCMonth Find a month name by the number of month
Quarter Returns a number equal to the quarter in which a date falls
Seconds Returns the number of elapsed seconds past midnight
Secs Return the number of seconds from the system date
SecToTime Converts seconds into a time string
Time Returns the system time as a string
TimeValid Determines whether a specified time is valid
TimeToSec Calculates the seconds since midnight
WaitPeriod Pauses a specified time in increments of 1/100 seconds
Week Returns the calendar week a number
WOY Gets the week number of the year
Year Converts the year portion of a date into a numeric value

CT_MDY

Posted on by vivaclipper 
 MDY()
 Returns a date in the "Month DD, YY" format

 Syntax

     MDY([<dDate>]) --> cDate

 Argument

     <dDate>  Designates the date from which to create a string.  The
     default is the system date.

 Returns

     MDY() returns a character string in Month DD, YY, or "Month DD, YYYY"
     format.

 Description

     MDY() returns the date in a character string that contains the day, name
     of month, and year.  The Clipper SET CENTURY ON/OFF switch determines
     whether or not the year is displayed in 2 or 4 digits.

     If the function is called without a parameter, it automatically uses the
     current system date.

 Note

     .  The returned month name always depends on which Clipper
        nations module is in use.  A German or French version of
        Clipper returns the appropriate month names, despite its
        characteristically American display.

 Examples
? "Today :", DATE(), MDY()
dDate := CTOD("02/01/89")
 
? dDate, MDY( dDate )

See Also: DMY()

Tools — Date/Time Functions

Posted on by vivaclipper 
Introduction Date/Time Functions
ADDMONTH()   Adds or subtracts months to/from a date
BOM()        Determines the date of the first day of a month
BOQ()        Determines the date for the beginning of a quarter
BOY()        Determines the date for the beginning of a year
CTODOW()     Converts the day of the week name into a corresponding number
CTOMONTH()   Converts the name of the month into a corresponding number
DMY()        Returns a date in "DD Month YY" format
DOY()        Determines the day of the year for a specific date
EOM()        Determines the date for the last day of a month
EOQ()        Determines the date for the end of a quarter
EOY()        Determines the date for the end of the year
ISLEAP()     Tests if a specific year is a leap year
LASTDAYOM()  Determines the number of days in a month
MDY()        Returns a date in the "Month DD, YY" format
NTOCDOW()    Changes the number of a weekday into a weekday name
NTOCMONTH()  Changes the number of a month into a month name
QUARTER()    Determines the quarter in which a specific date lies
SECTOTIME()  Converts seconds into a time string
SETDATE()    Sets the system date
SETTIME()    Sets the system clock
SHOWTIME()   Continuously displays the time at desired screen position
STOD()       Converts an ANSI date string into Clipper format
TIMETOSEC()  Calculates the seconds since midnight
TIMEVALID()  Determines whether a specified time is valid
WAITPERIOD() Pauses a specified time in increments of 1/100 seconds
WEEK()       Returns the calendar week for a date
WOM()        Returns the week within a month.