Group Date and Time Functions

Adds a number of months to a date value.

AddMonth( [<dDate>], ; // Default: Date() <nMonths> ) --> dNewDate

Determines the date of the first day in a month.

BoM( [<dDate>] ; // Default: Date() ) --> dBeginOfMonth

Determines the date for the beginning of a quarter.

BoQ( [<dDate>] ; // Default: Date() ) --> dBeginOfQuarter

Determines the date for the beginning of a year.

BoY( [<dDate>] ; // Default: Date() ) --> dBeginOfYear

Converts a week day to its corresponding number.

CtoDoW( <cDayOfWeek> ) --> nDayOfWeek

Converts a month name to its corresponding number.

CtoMonth( <cMonthName> ) --> nMonth

Creates a date string in the format "dd. Month yy"

DMY( [<dDate>], ; // Default: Date() [<lInsertFullStop>] ; // Default: .F. ) --> cDate

Calculates the number of a day in a year.

DoY( [<dDate>] ; // Default: Date() ) --> nDayOfYear

Determines the date of the last day in a month.

EoM( [<dDate>] ; // Default: Date() ) --> dEndOfMonth

Determines the date of the last day in a quarter.

EoQ( [<dDate>] ; // Default: Date() ) --> dEndOfQuarter

Determines the date for the end of a year.

EoY( [<dDate>] ; // Default: Date() ) --> dEndOfYear

Checks whether a year is a leap year.

IsLeap( [<dDate>] ; // Default: Date() ) --> lIsLeapYear

Determines the number of days in a month.

LastDayoM( [<dDate|nMonth>] ; // Type: DN Default: Date() ) --> nNumberOfDaysInMonth

Creates a date string in the format "Month dd, yy"

MDY( [<dDate>] ; // Default: Date() ) --> cDate

Converts a numeric week day to a string (1 = Sunday)

NtoCDoW( <nDayOfWeek> ) --> cDayOfWeek

Converts a numeric month to a string (1 = January).

NtoCMonth( <nMonth> ) --> cMonthName

Determines the quarter a date belongs to.

Quarter( [<dDate>] ; // Default: Date() ) --> nQuarter

Converts seconds to a time string.

SecToTime( <nSeconds>, [<lHundredths>] ; // Default: .F. ) --> cTime

Sets the system date.

SetDate( <dDate> ; // Default: Date() ) --> lSuccess

Sets the system time.

SetTime( <cTime> ) --> lSuccess

Displays the system time continuously at the specified position on screen.

ShowTime( [<nRow>], ; // Default: Row() [<nColumn>], ; // Default: Col() [<lNoSeconds>], ; // Default: .F. [<cColorAttr>], ; // Default: GetClearA() [<l12h_Format>], ; // Default: .F. [<lAM_PM>] ; // Default: .F. ) --> cNullString

StoD() is part of the Xbase++ runtime DLL.

StoD() --> dDate

Converts a time string to the number of seconds elapsed since midnight.

TimeToSec( [<cTime>] ; // Default: Time() ) --> nSeconds

Validates a time string.

TimeValid( <cTime> ) --> lValidTimeString

Allows time controlled loops.

WaitPeriod( [<nWaitPeriod>] ) --> lPeriodNotPassed

Calculates the calendar week from a date.

Week( [<dDate>], [<lSundayIsFirstDayOfWeek>] ) --> nWeekOfYear

Calculates the week number in a month.

WoM( [<dDate>] ; // Default: Date() ) --> nWeekOfMonth