TRUE || FALSE BETWEEN(<TargetData>, <FirstData>, <SecondData>) cDayName CDOW(<dExp>) cMonth CMONTH(<dDate>) dDate CTOD(<cDate>) dSystem DATE() nDay DAY(<dDate>) nDay DOW(<dDate>) cDate DTOC(<dDate>) cDate DTOS(<dDate>) lEmpty EMPTY(<exp>) dDate FT_ACCTADJ( [ <dGivenDate> ], [ <lIsEnd> ] ) aDateInfo FT_ACCTMONTH( [ <dGivenDate> ], [ <nMonthNum> ] ) aDateinfo FT_ACCTQTR( [ <dGivenDate> ], [ <nQtrNum> ] ) aDateInfo FT_ACCTWEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) aDateInfo FT_ACCTYEAR( [ <dGivenDate> ] ) nTrueDays FT_ADDWKDY( <dStart>, <nWorkDays> ) aRetVal FT_CALENDAR ( [ <nRow> ], [ <nCol> ], [ <cColor> ], [ <lShadow> ] , [ <lShowHelp> ] ) cMILTIME FT_CIV2MIL( <cCIVTIME> ) aDateInfo FT_DATECNFG( [ <cFYStart> ], [ <nDow> ] ) aDateInfo FT_DAYOFYR( [ <dGivenDate> ], [ <nDayNum> ], [ <lIsAcct> ] ) nDays FT_DAYTOBOW( [ <dGivenDate> ] ) <nResult> FT_DOY( <dDate> ) dEdate FT_EASTER( <xYear> ) nMINUTES FT_ELAPMIN( <cTIME1>, <cTIME2> ) aTimedata FT_ELAPSED([ <dStart> ], [ <dEnd> ], ; <cTimeStart>, <cTimeEnd>) cDiff FT_ELTIME( <cTime1>, <cTime2> ) dFirstDay FT_FDAY( [ <dDateToChk> ] ) dLastDay FT_LDAY( [ <dDateToChk> ] ) dDate FT_MADD( [ <dGivenDate> ], [ <nAddMonths> ], [ <lMakeEOM> ] ) dMILTIME FT_MIL2CIV( <cCIVTIME> ) nMINUTE FT_MIL2MIN( <cMILTIME> ) aDHM_ FT_MIN2DHM( <nMinutes> ) cMILTIME FT_MIN2MIL( <nMINUTE> ) aDateInfo FT_MONTH( [ <dGivenDate> ], [nMonthNum] ) aDateInfo FT_QTR( [ <dGivenDate> ], [ <nQtrNum> ] ) cMILTIME FT_SYS2MIL() aDateinfo FT_WEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) nDays FT_WORKDAYS( [ <dStart> ], [ <dStop> ] ) <nResult> FT_WOY( <dDate> ) aDateInfo FT_YEAR( [ <dGivenDate> ] ) dLarger MAX(<nExp1>, <nExp2>) --> nLarger MAX(<dExp1>, <dExp2>) dSmaller MIN(<nExp1>, <nExp2>) --> nSmaller MIN(<dExp1>, <dExp2>) nMonth MONTH(<dDate>) NIL QOUT([<exp list>]) --> NIL QQOUT([<exp list>]) nSeconds SECONDS() NIL SLEEP(<nSec>) cTimeString TIME() cFormatString TRANSFORM(<exp>, <cSayPicture>) cType TYPE(<cExp>) cType VALTYPE(<exp>) nYear YEAR(<dDate>)
CDOW(<выражение типа дата>) --> название дня недели
CDOW() - это функция преобразования, которая используется для форматированной выдачи даты в отчеты, метки и на экран.
<выражение типа дата> | - значение преобразуемой даты. |
Returns : | CDOW() возвращает название дня недели в виде символьной строки. Первая буква - заглавная ( в верхнем регистре ), остальные - строчные (в нижнем регистре). Для нулевой даты CDOW() возвращает пустую строку (""). |
See also : | CTOD() DATE() DAY() DOW() |
CMONTH(<дата>) --> название месяца
CMONTH() - функция преобразования дат, которая предназначена для создания форматированных дат, представленных в виде символьных строк, для отчетов, меток, при выдаче на экран.
<дата> | - дата для преобразования. |
Returns : | CMONTH() возвращает название месяца по заданной дате в виде строки символов. Первый символ названия месяца - заглавный (в верхнем регистре), остальные - строчные ( в нижнем регистре ). Для нулевой даты CMONTH() возвращает пустую строку (""). |
See also : | CDOW() DATE() DAY() MONTH() YEAR() |
CTOD(<строка-дата>) --> дата
CTOD() - это функция преобразования символьных строк, которая преобразует строку символов в дату. Для формирования пустой даты необходимо задать <строка-дата> либо в виде строки нулевой длины (""), либо строкой SPACE(8), либо строкой "//".
CTOD() используется везде, где необходима дата в виде литеральной строки. Например:
При инициализации переменной для хранения дат
При определении литеральной строки, содержащей дату как аргумента предложения RANGE команды @...GET
При определении литеральной строки, содержащей дату, для выполнения арифметических действий над ней
При сравнении результата выполнения выражения над датами с литеральной строкой
При присваивании значения литеральной строки полю типа дата
Функция CTOD() обратна по действию функции DTOC(), которая преобразует значение переменной типа дата в литеральную строку в формате, определенном командами SET DATE и SET CENTURY. DTOC() также преобразует значение переменной типа дата в строку символов в формате ггггммдд.
<строка-дата> | - строка символов, состоящая из чисел, представляющих собой номер месяца, дня и года, разделенные любым символом, кроме цифр. День, месяц и год должны быть заданы в соответствии с установленным командой SET DATE форматом. Если не задано число, определяющее век, оно определяется установкой команды SET EPOCH. |
Returns : | CTOD() возвращает значение даты. Если <строка-дата> задана некорректно, CTOD() возвращает пустую дату. |
See also : | DATE() DTOC() DTOS() |
DATE() --> системная дата
DATE() - функция получения дат, которая дает возможность устанавливать начальные значения переменных памяти в виде текущей даты, сравнивать другие даты с текущей датой, производить арифметические вычисления над датами с участием текущей даты. Формат вывода даты на дисплей устанавливается командой SET DATE.
Формат, установленный по умолчанию мм/дд/гг.
DAY(<дата>) --> номер дня
DAY() - функция преобразования даты, которая используется для преобразования значения даты в номер дня в месяце. Она используется в комбинации с функциями CMONTH() и YEAR() для форматирования дат, а также при различных вычислениях над датами.
<дата> | - подлежащая преобразованию дата. |
Returns : | DAY() возвращает целое число в пределах от нуля до 31. Если заданный месяц - февраль, предполагается високосный год. Если аргумент имеет значение 29 февраля и год не високосный, DAY() возвращает 0. Если аргумент пустой, DAY() возвращает 0. |
See also : | CDOW() CMONTH() DOW() MONTH() STR() YEAR() |
DOW(<дата>) --> номер дня
DOW() - это функция преобразования даты, которая преобразует значение даты в число, идентифицирующее день недели. Функция полезна при выполнении расчетов над днями недели. Функция DOW() похожа на функцию CDOW(), которая возвращает день недели в виде строки символов вместо числа.
DTOC(<дата>) --> строка-дата
DTOC() - функция преобразования даты, которая используется, когда нужно выделить дату в формате, установленном командой SET DATE в качестве элемента символьного выражения (например, при выводе меток). Если требуется специальный формат даты, вы можете использовать функцию TRANSFORM() или соответствующее выражение. Если вы включаете дату как элемент символьного выражения в индекс, для преобразования даты необходимо использовать DTOS() вместо DTOC().
<дата> | - это дата, значение которой преобразуется. |
Returns : | DTOC() возвращает дату, представленную в виде строки символов. Возвращаемое значение форматируется с учетом установленного текущего формата даты. По умолчанию принимается формат мм/дд/гг. Нулевая дата преобразуется в строку пробелов, равную длине, принятой для формата даты. |
See also : | CTOD() DATE() DTOS() |
DTOS(<дата>) --> строка-дата
DTOS() - это функция преобразования даты, которая используется при создании выражений индексов, содержащих значения даты, в строку символов, которая может быть сцеплена с какими-либо другими символьными выражениями. Структура возвращаемого значения - всегда ггггммдд.
<дата> | - преобразуемое значение даты. |
Returns : | DTOS() возвращает строку длиной в 5 символов в формате ггггммдд. Если значение аргумента <дата> имеет нулевое значение, (CTOD("")), DTOS() возвращает строку из восьми пробелов. Формат возвращаемой строки не зависит от текущей установки формата командой SET DATE. |
See also : | CTOD() DATE() DTOC() |
FT_ACCTADJ( [ <dGivenDate> ], [ <lIsEnd> ] ) --> dDate
Called by other FT_ACCT.. functions. The algorithm is:
Beginning of period mode:
If dGivenDate is in last 3 days of work week Return next week's start date Else Return this week's start date Endif
End of period mode:
If dGivenDate is in last 4 days of work week Return this week's end date Else Return prior week's end date Endif
<dGivenDate> | is any valid date in any valid format. Defaults to DATE() if not supplied. |
<lIsEnd> | is a logical variable. .F. = adjust for beginning of period mode, .T. = adjust for end of period mode. Defaults to beginning of period mode. |
Returns : | An adjusted date dependent upon mode and work week start day. |
See also : | FT_DATECNFG() FT_DAYTOBOW() |
FT_ACCTMONTH( [ <dGivenDate> ], [ <nMonthNum> ] ) --> aDateInfo
FT_ACCTMONTH() creates an array containing data about the accounting month containing the given date.
An accounting period has the following characteristics:
If the first week of the period contains 4 or more 'work' days, it is included in the period; otherwise, the first week was included in the prior period.
If the last week of the period contains 4 or more 'work' days it is included in the period; otherwise, the last week is included in the next period. This results in 13 week 'quarters' and 4 or 5 week 'months'. Every 5 or 6 years, a 'quarter' will contain 14 weeks and the year will contain 53 weeks.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nMonthNum> | is a number from 1 to 12 signifying a month. Defaults to current month if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year and month as a character string "YYYYMM" aDateInfo[2] - The beginning date of the accounting month aDateInfo[3] - The ending date of the accounting month |
See also : | FT_DATECNFG() FT_ACCTWEEK() FT_ACCTQTR() FT_ACCTYEAR() |
FT_ACCTQTR( [ <dGivenDate> ], [ <nQtrNum> ] ) --> aDateinfo
FT_ACCTQTR() creates an array containing data about the accounting quarter containing the given date.
An accounting period has the following characteristics:
If the first week of the period contains 4 or more 'work' days, it is included in the period; otherwise, the first week was included in the prior period.
If the last week of the period contains 4 or more 'work' days it is included in the period; otherwise, the last week is included in the next period. This results in 13 week 'quarters' and 4 or 5 week 'months'. Every 5 or 6 years, a 'quarter' will contain 14 weeks and the year will contain 53 weeks.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nQtrNum> | is a number from 1 to 4 signifying a quarter. Defaults to current quarter if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year and qtr. as a character string "YYYYQQ" aDateInfo[2] - The beginning date of the accounting quarter aDateInfo[3] - The ending date of the accounting quarter |
See also : | FT_DATECNFG() FT_ACCTWEEK() FT_ACCTMONTH() FT_ACCTYEAR() |
FT_ACCTWEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) --> aDateInfo
FT_ACCTWEEK() returns an array containing data about the accounting week containing the given date.
An accounting period has the following characteristics:
If the first week of the period contains 4 or more 'work' days, it is included in the period; otherwise, the first week was included in the prior period.
If the last week of the period contains 4 or more 'work' days it is included in the period; otherwise, the last week is included in the next period. This results in 13 week 'quarters' and 4 or 5 week 'months'. Every 5 or 6 years, a 'quarter' will contain 14 weeks and the year will contain 53 weeks.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nWeekNum> | is a number from 1 to 52 signifying a week. Defaults to current week if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year and week as a character string "YYYYWW" aDateInfo[2] - The beginning date of the accounting week aDateInfo[3] - The ending date of the accounting week |
See also : | FT_DATECNFG() FT_ACCTMONTH() FT_ACCTQTR() FT_ACCTYEAR() |
FT_ACCTYEAR( [ <dGivenDate> ] ) --> aDateInfo
FT_ACCTYEAR() creates an array containing data about the accounting year containing the given date.
An accounting period has the following characteristics:
If the first week of the period contains 4 or more 'work' days, it is included in the period; otherwise, the first week was included in the prior period.
If the last week of the period contains 4 or more 'work' days it is included in the period; otherwise, the last week is included in the next period. This results in 13 week 'quarters' and 4 or 5 week 'months'. Every 5 or 6 years, a 'quarter' will contain 14 weeks and the year will contain 53 weeks.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year as a character string "YYYY" aDateInfo[2] - The beginning date of the accounting year aDateInfo[3] - The ending date of the accounting year |
See also : | FT_DATECNFG() FT_ACCTWEEK() FT_ACCTMONTH() FT_ACCTQTR() |
FT_ADDWKDY( <dStart>, <nWorkDays> ) --> nTrueDays
Let's say you are given the problem:
"All invoices are due 10 working days from the date they are printed. Please display the due date on the invoice."
When is the due date? Assuming you are printing the invoices today, your answer is:
dDueDate := DATE() + ft_addWkDay( DATE(), 10 )
A work day is defined as Monday through Friday. Unfortunately this routine does _not_ account for holidays.
This documentation was written by Glenn Scott so if it's wrong, blame him.
<dStart> | = date to start adding from |
<nWorkDays> | = number of workdays to add |
Returns : | <nTrueDays> = Number of actual days to add to <dStart> in order to add the required <nWorkDays> |
See also : | FT_WORKDAYS() |
FT_CALENDAR ( [ <nRow> ], [ <nCol> ], [ <cColor> ], [ <lShadow> ] , [ <lShowHelp> ] ) --> aRetVal
FT_CALENDAR() simply displays today's date, time and julian day in a two line display with an optional box shadow. Cursor keys may be used to page through the calendar by day, week, month or year increments. Returns an 8 element array of calendar data:
Element Value [1] Date in current date format. [2] Numeric month number. [3] Numeric day number. [4] Numeric year number. [5] Month in character format. [6] Day of the week in character format. [7] Numeric Julian day. [8] Current time in time format.
WARNING: FT_CALENDAR uses FT_SHADOW and FT_XBOX from the Nanforum Toolkit!
<nRow> | is an optional screen row for calendar display, default row 1. |
<nCol> | is an optional screen col for calendar display, default col 63. |
<cColor> | is an optional color string for displayed messages, default is bright white text over green background. |
<lShadow> | is an optional logical variable. If true (.T.), it uses FT_SHADOW() to add a transparent shadow to the display, default (.F.). |
<lShowHelp> | is an optional logical variable. If true, uses FT_XBOX to display a four line help message if the F1 key is pressed, default (.F.). |
Returns : | aRetVal is an 8 element array containing date, month, day, year, month (in character format), day of the week, julian day and current time. |
See also : | FT_DAYOFYR() |
FT_CIV2MIL( <cCIVTIME> ) --> cMILTIME
Converts time from 12-hour civilian format to military.
<cCIVTIME> | character string of form hh:mm (am,pm,n or m), where 0<hh<12. |
Returns : | <cMILTIME> character string of form hhmm, where 0<=hh<24. |
See also : | FT_MIL2CIV() FT_SYS2MIL() FT_MIL2MIN() FT_MIN2MIL() |
FT_DATECNFG( [ <cFYStart> ], [ <nDow> ] ) --> aDateInfo
FT_DATECNFG() is called internally by many of the date functions in the library to determine the beginning of year date and beginning of week day.
The default beginning of the year is January 1st and the default beginning of the week is Sunday (day 1). Either or both of these settings may be changed by calling FT_DATECNFG() with the proper arguments. They will retain their values for the duration of the program or until they are changed again by a subsequent call to FT_DATECNFG().
It is not necessary to call FT_DATECNFG() unless you need to change the defaults.
FT_DATECNFG() affects the following library functions:
FT_WEEK() FT_ACCTWEEK() FT_DAYTOBOW() FT_MONTH() FT_ACCTMONTH() FT_DAYOFYR() FT_QTR() FT_ACCTQTR() FT_ACCTADJ() FT_YEAR() FT_ACCTYEAR()
<cFYStart> | is a character date string in the user's system date format, i.e., the same as the user would enter for CTOD(). If this argument is NIL, the current value is unchanged. Note: The year portion of the date string must be present and be a valid year; however, it has no real meaning. |
<nDow> | is a number from 1 to 7 (1 = Sunday) indicating the desired start of a work week. If this argument is NIL, the current value is unchanged. |
Returns : | A 2-element array containing the following information: aDateInfo[1] - an ANSI date string indicating the beginning date of the year. Only the month and day are meaningful. aDateInfo[2] - the number of the first day of the week (1 = Sunday) |
See also : | FT_ACCTADJ() |
FT_DAYOFYR( [ <dGivenDate> ], [ <nDayNum> ], [ <lIsAcct> ] ) --> aDateInfo
FT_DAYOFYR() returns an array containing data about a day in the calendar or fiscal year containing the given date.
The beginning of year date defaults to January 1st but may be changed with FT_DATECNFG().
<dGivenDate> | is any valid date in any valid format. Defaults to current system date if not supplied. |
<nDayNum> | is a number from 1 to 371, signifying a day of a year. Defaults to current day if not supplied. |
<lIsAcct> | is a logical which specifies the type of year to base the return value on: .F. = calendar or fiscal year, .T. = accounting year. |
Returns : | A three element array containing the following data: If <nDayNum> is specified: aDateInfo[1] - The date of the specified day number aDateInfo[2] - The beginning date of the year aDateInfo[3] - The ending date of the year If <nDayNum> is not specified: aDateInfo[1] - The year and day as a character string "YYYYDDD" aDateInfo[2] - The beginning date of the year aDateInfo[3] - The ending date of the year |
See also : | FT_DATECNFG() |
FT_DAYTOBOW( [ <dGivenDate> ] ) --> nDays
FT_DAYTOBOW() returns the number of days to the beginning of the week. Normally this will be one less than the value that would be returned by the Clipper function DOW(), unless the day for the beginning of the week has been changed with FT_DATECNFG().
<dGivenDate> | is any valid date in any valid date format. Defaults to current date if not supplied. |
Returns : | A positive number of days to beginning of week, range 0 to 6. |
See also : | FT_DATECNFG() FT_ACCTWEEK() FT_WEEK() |
FT_DOY( <dDate> ) --> <nResult>
Finds the day number, considering 01/01 as day 1 Handles dates with CENTURY ON|OFF, to allow for 21st century. Date validation must be external to this function.
FT_EASTER( <xYear> ) --> dEdate
Returns the date of Easter for any year after 1582 up to Clipper's limit which the manual states is 9999, but the Guide agrees with the actual imposed limit of 2999.
This function can be useful in calender type programs that indicate when holidays occur.
FT_ELAPMIN( <cTIME1>, <cTIME2> ) --> nMINUTES
Finds the arithmetic difference between time two times (time 2 - time 1). If time 2 is smaller than time 1, a NEGATIVE value is returned.
<cTIME1, cTIME2> | character strings of military form "hhmm", where 0<=hh<24. |
Returns : | <nMINUTES> |
See also : | FT_ELTIME() FT_MIL2MIN() FT_MIN2MIL() |
FT_ELAPSED([ <dStart> ], [ <dEnd> ], ; <cTimeStart>, <cTimeEnd>) --> aTimedata
FT_ELAPSED() calculates the elapsed time between two Date/Time events.
It returns an array which contains the following data:
aRetVal[1,1] Integer Days aRetVal[1,2] Total Days (nn.nnnn) aRetVal[2,1] Integer Hours aRetVal[2,2] Total Hours (nn.nnnn) aRetVal[3,1] Integer Minutes aRetVal[3,2] Total Minutes (nn.nnnn) aRetVal[4,1] Integer Seconds aRetVal[4,2] Total Seconds (nn)
<dStart> | is any valid date in any date format. Defaults to DATE(). |
<dEnd> | is any valid date in any date format. Defaults to DATE(). |
<cTimeStart> | is a valid Time string of the format 'hh:mm:ss' where hh is hours in 24-hour format. |
<cTimeEnd> | is a valid Time string of the format 'hh:mm:ss' where hh is hours in 24-hour format. |
Returns : | A two-dimensional array containing elapsed time data. |
FT_ELTIME( <cTime1>, <cTime2> ) --> cDiff
Return the absolute difference between two times in hh:mm:ss format in character hours, minutes and seconds (hh:mm:ss).
<cTime1, cTime2> | character strings representing times in hh:mm:ss format. |
Returns : | <cDiff> character string representing time difference in hh:mm:ss format. |
See also : | FT_ELAPMIN() FT_MIL2MIN() FT_MIN2MIL() |
FT_FDAY( [ <dDateToChk> ] ) --> dFirstDay
This function will return the first day of the month of the date passed, or the first day of the current month if no argument is supplied.
<dDateToChk> | is a date within a month for which you want to find the first date of that month. If not passed or is an incorrect type, defaults to current system date. |
Returns : | A Clipper date value representing the first date of the month. |
See also : | FT_LDAY() |
FT_LDAY( [ <dDateToChk> ] ) --> dLastDay
This function will return the last day of the month of the date passed, or the last day of the current month if no argument is supplied.
<dDateToChk> | is a date within a month for which you want to find the last date of that month. If not passed or is an incorrect type, defaults to current system date. |
Returns : | A Clipper date value representing the last date of the month. |
See also : | FT_FDAY() |
FT_MADD( [ <dGivenDate> ], [ <nAddMonths> ], [ <lMakeEOM> ] ) --> dDate
FT_MADD() adds or subtracts months to/from a given date.
If MakeEOM is passed and dGivenDate is the last day of a month, it will return the EOM of calculated month. Otherwise it will return the same day as the day of the passed date.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nAddMonths> | is the number of months to be added or subtracted. Defaults to 0 if not supplied. |
<lMakeEOM> | is a logical variable indicating whether or not to force the returned date to the last date of the month. It only affects the returned date if <dGivenDate> is an end-of-month date. |
Returns : | A date. |
See also : | FT_DAYOFYR() FT_DAYTOBOW() |
FT_MIL2CIV( <cCIVTIME> ) --> dMILTIME
Converts time from military to civilian format
<cMILTIME> | character string of form hhmm, where 0<=hh<24. |
Returns : | <cCIVTIME> character string of form hh:mm (am,pm,n or m), where 0<hh<12. |
See also : | FT_CIV2MIL() FT_SYS2MIL() FT_MIL2MIN() FT_MIN2MIL() |
FT_MIL2MIN( <cMILTIME> ) --> nMINUTE
Converts time in military format to number of minute of the day.
<cMILTIME> | character string of form hhmm, where 0<=hh<24. |
Returns : | <nMINOFDAY> numeric value representing minute of day. |
See also : | FT_MIN2MIL() FT_CIV2MIL() FT_MIL2CIV() FT_SYS2MIL() |
FT_MIN2DHM( <nMinutes> ) --> aDHM_
Converts numeric minutes into a character array containing days, hours & minutes.
FT_MIN2MIL( <nMINUTE> ) --> cMILTIME
Converts minute of the day to military format time.
<nMINUTE> | numeric integer representing minute of day. |
Returns : | <cMILTIME> character string of form hhmm, where 0<=hh<24. |
See also : | FT_MIL2MIN() FT_MIL2CIV() FT_CIV2MIL() FT_SYS2MIL() |
FT_MONTH( [ <dGivenDate> ], [nMonthNum] ) --> aDateInfo
FT_MONTH() returns an array containing data about the month containing the given date.
Normally the return data will be based on a year beginning on January 1st with weeks beginning on Sunday.
The beginning of year date and/or beginning of week day can be changed by using FT_DATECNFG(), which will affect all subsequent calls to FT_MONTH() until another call to FT_DATECNFG().
The beginning of year date and beginning of week day may be reset to January 1 and Sunday by calling FT_DATECNFG() with no parameters.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nMonthNum> | is a number from 1 to 12 signifying a month. Defaults to current month if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year and month as a character string "YYYYMM" aDateInfo[2] - The beginning date of the month aDateInfo[3] - The ending date of the month |
See also : | FT_DATECNFG() FT_WEEK() FT_QTR() FT_YEAR() |
FT_QTR( [ <dGivenDate> ], [ <nQtrNum> ] ) --> aDateInfo
FT_QTR() returns an array containing data about the quarter containing the given date.
Normally the return data will be based on a year beginning on January 1st with weeks beginning on Sunday.
The beginning of year date and/or beginning of week day can be changed by using FT_DATECNFG(), which will affect all subsequent calls to FT_QTR() until another call to FT_DATECNFG().
The beginning of year date and beginning of week day may be reset to January 1 and Sunday by calling FT_DATECNFG() with no parameters.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nQtrNum> | is a number from 1 to 4 signifying a quarter. Defaults to current quarter if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year and quarter as a character string "YYYYQQ" aDateInfo[2] - The beginning date of the quarter aDateInfo[3] - The ending date of the quarter |
See also : | FT_DATECNFG() FT_WEEK() FT_MONTH() FT_YEAR() |
FT_SYS2MIL() --> cMILTIME
Return current system time as character string in military format.
Returns : | <cMILTIME> character string of form hhmm, where 0<=hh<24. |
See also : | FT_MIL2CIV() FT_CIV2MIL() |
FT_WEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) --> aDateinfo
FT_WEEK() returns an array containing data about the week containing the given date.
Normally the return data will be based on a year beginning on January 1st with weeks beginning on Sunday.
The beginning of year date and/or beginning of week day can be changed by using FT_DATECNFG(), which will affect all subsequent calls to FT_WEEK() until another call to FT_DATECNFG().
The beginning of year date and beginning of week day may be reset to January 1 and Sunday by calling FT_DATECNFG() with no parameters.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
<nWeekNum> | is a number from 1 to 53 signifying a week. Defaults to current week if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year and week as a character string "YYYYWW" aDateInfo[2] - The beginning date of the week aDateInfo[3] - The ending date of the week |
See also : | FT_DATECNFG() FT_MONTH() FT_QTR() FT_YEAR() FT_DAYTOBOW() |
FT_WORKDAYS( [ <dStart> ], [ <dStop> ] ) --> nDays
FT_WORKDAYS() returns a number indicating the number of work days between two dates. Work days are considered Monday through Friday. (The five day work week none of us Clipper programmers have.)
FT_WOY( <dDate> ) --> <nResult>
Considers a full week as starting on Sunday, ending on Saturday. First week of year (week 1) may start on any day, and thus contain any number of days. Final week of year (week 53) may contain any number of days. Handles dates with CENTURY ON|OFF, to allow for 21st century. Date validation must be external to this function.
FT_YEAR( [ <dGivenDate> ] ) --> aDateInfo
FT_YEAR() returns an array containing data about the year containing the given date.
Normally the return data will be based on a year beginning on January 1st.
The beginning of year date can be changed by using FT_DATECNFG(), which will affect all subsequent calls to FT_YEAR() until another call to FT_DATECNFG().
The beginning of year date may be reset to January 1 by calling FT_DATECNFG() with no parameters.
<dGivenDate> | is any valid date in any date format. Defaults to current system date if not supplied. |
Returns : | A three element array containing the following data: aDateInfo[1] - The year as a character string "YYYY" aDateInfo[2] - The beginning date of the year aDateInfo[3] - The ending date of the year |
See also : | FT_DATECNFG() FT_WEEK() FT_MONTH() FT_QTR() |
MONTH(<дата>) --> номер месяца
MONTH() - функция обработки даты, которая может быть полезна, если в процессе вычислений необходимо числовое значение месяца. MONTH() входит в группу функций, которые возвращают компоненты даты как целое число. В эту группу также входят функции DAY() и YEAR(), которые возвращают числовые значения дня и года. Функция CMONTH() позволяет по значению даты определить название месяца.
SECONDS() --> количество секунд
SECONDS() - это функция получения времени, используемая для обеспечения простого метода вычисления интервалов времени. Она использует системный таймер. SECONDS() родственна функции TIME(), которая возвращает системное время в виде строки формата чч:мм:сс.
Returns : | SECONDS() возвращает системное время как числовое значение до сотых долей секунды. Возвращенное числовое значение - это количество секунд, отсчитываемое от полуночи. Диапазон его значений - от 0 до 86399. |
See also : | TIME() |
TIME() --> системное время.
TIME() - функция получения времени, используемая для вызова на экран или печатающее устройство системного времени. TIME() связана с функцией SECONDS(), которая возвращает количество секунд с начала суток. Вместо TIME() для вычислений обычно используется SECONDS().
YEAR (<дата>) --> год
YEAR() - функция преобразования даты, которая используется для перевода заданной даты в числовое значение года. Функция может быть использована при вычислениях или для форматирования дат. YEAR() входит в группу функций, которые возвращают компоненты дат в виде чисел. К этой группе относятся также функции DAY() и MONTH(), которые возвращают значения дня и месяца в виде числовых значений.
Пред. | Начало | След. |
NETWARE | Уровень выше | KEYBOARD/MOUSE |