13.19. DATE/TIME

About
Functions order

13.19.1. About DATE/TIME

13.19.2. DATE/TIME functions order

BETWEEN() Check value.
CDOW() Convert a date value to a character day of the week
CMONTH() Convert a date to a character month name
CTOD() Convert a date string to a date value
DATE() Return the system date as a date value
DAY() Return the day of the month as a numeric value
DOW() Convert a date value to a numeric day of the week
DTOC() Convert a date value to a character string
DTOS() Convert a date value to a character string formatted as yyyymmdd
EMPTY() Determine if the result of an expression is empty
FT_ACCTADJ() Adjust beginning or ending fiscal pd. dates to acctg. dates
FT_ACCTMONTH() Return accounting month data
FT_ACCTQTR() Return accounting quarter data
FT_ACCTWEEK() Return accounting week data
FT_ACCTYEAR() Return accounting year data
FT_ADDWKDY() Return true number of days to add given number of workdays
FT_CALENDAR() Display date/time calendar, find a date, return calendar data.
FT_CIV2MIL() Convert usual civilian format time to military time.
FT_DATECNFG() Set beginning of year/week for FT_ date functions
FT_DAYOFYR() Return calendar, fiscal or accounting day data
FT_DAYTOBOW() Calculate no. of days between date and beginning of week
FT_DOY() Find number of day within year
FT_EASTER() Return the date of Easter
FT_ELAPMIN() Return difference, in minutes, between two mil format times.
FT_ELAPSED() Return elapsed time between two days and/or times
FT_ELTIME() Compute difference between times in hours, minutes, seconds.
FT_FDAY() Return first day of the month
FT_LDAY() Return last day of the month
FT_MADD() Add or subtract months to/from a date
FT_MIL2CIV() Convert time in military format to civilian format.
FT_MIL2MIN() Convert time in military format to number of minute of day.
FT_MIN2DHM() Convert numeric minutes to days, hours and minutes.
FT_MIN2MIL() Convert minute of day to military format time.
FT_MONTH() Return Calendar or Fiscal Month Data
FT_QTR() Return Calendar or Fiscal Quarter Data.
FT_SYS2MIL() Convert system time to military time format.
FT_WEEK() Return calendar or fiscal week data
FT_WORKDAYS() Return number of work days between two dates
FT_WOY() Find number of week within year
FT_YEAR() Return calendar or fiscal year data
MAX() Return the larger of two numeric or date values
MIN() Return the smaller of two numeric or date values
MONTH() Convert a date value to the number of the month
QOUT() Display a list of expressions to the console
SECONDS() Return the number of seconds elapsed since midnight
SLEEP() Sleep for the specified number of seconds and milliseconds.
TIME() Return the system time
TRANSFORM() Convert any value into a formatted character string
TYPE() Determine the type of an expression
VALTYPE() Determine the data type returned by an expression
YEAR() Convert a date value to the year as a numeric value

13.19.2.3. Function CTOD()

 CTOD(<cDate>) --> dDate

13.19.2.10. Function FT_ACCTMONTH()

 FT_ACCTMONTH( [ <dGivenDate> ], [ <nMonthNum> ] ) -> aDateInfo

13.19.2.11. Function FT_ACCTQTR()

 FT_ACCTQTR( [ <dGivenDate> ], [ <nQtrNum> ] ) -> aDateinfo

13.19.2.12. Function FT_ACCTWEEK()

 FT_ACCTWEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) -> aDateInfo

13.19.2.15. Function FT_CALENDAR()

 FT_CALENDAR ( [ <nRow> ], [ <nCol> ], [ <cColor> ], [ <lShadow> ] ,
 [ <lShowHelp> ] ) -> aRetVal

13.19.2.17. Function FT_DATECNFG()

 FT_DATECNFG( [ <cFYStart> ], [ <nDow> ] ) -> aDateInfo

13.19.2.18. Function FT_DAYOFYR()

 FT_DAYOFYR( [ <dGivenDate> ], [ <nDayNum> ], [ <lIsAcct> ] )
 -> aDateInfo

13.19.2.32. Function FT_MONTH()

 FT_MONTH( [ <dGivenDate> ], [nMonthNum] ) -> aDateInfo

13.19.2.33. Function FT_QTR()

 FT_QTR( [ <dGivenDate> ], [ <nQtrNum> ] ) -> aDateInfo

13.19.2.35. Function FT_WEEK()

 FT_WEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) -> aDateinfo