User Guide

12 Quick Reference to CFML
CFML Functions
Array functions
ArrayAppend(
array
,
value
)
ArrayAvg(
array
)
ArrayClear(
array
)
ArrayDeleteAt(
array
,
position
)
ArrayInsertAt(
array
,
position
,
value
)
ArrayIsEmpty(
array
)
ArrayLen(
array
)
ArrayMax(
array
)
ArrayMin(
array
)
ArrayNew(
dimension
)
ArrayPrepend(
array
,
value
)
ArrayResize(
array
,
minimum_size
)
ArraySet(
array
,
start_pos
,
end_pos
,
value
)
ArraySort(
array
,
sort_type
[,
sort_order
])
ArraySum(
array
)
ArraySwap(
array
,
position1
,
position2
)
ArrayToList(
array
[,
delimiter
])
IsArray(
value
[,
number
])
ListToArray(
list
[,
delimiter
])
Date and time functions
CreateDate(
year
,
month
,
day
)
CreateDateTime(
year
,
month
,
day
,
hour
,
minute
,
second
)
CreateODBCDate(
date
)
CreateODBCDateTime(
date
)
CreateODBCTime(
date
)
CreateTime(
hour
,
minute
,
second
)
CreateTimeSpan(
days
,
hours
,
minutes
,
seconds
)
DateAdd(
datepart
,
number
,
date
)
DateCompare(
date1
,
date2
[,
datePart
])
DateConvert(
conversion-type
,
date
)
DateDiff(
datepart
,
date1
,
date2
)
DateFormat(
date
[,
mask
])
DatePart(
datepart
,
date
)
Day(
date
)
DayOfWeek(
date
)
DayOfWeekAsString(
day_of_week
)
DayOfYear(
date
)
DaysInMonth(
date
)
Hour(
date
)
IsDate(
string
)
IsLeapYear(
year
)
IsNumericDate(
number
)
LSParseDateTime(
date-time-string
)
Minute(
date
)
Month(
date
)
MonthAsString(
month_number
)
Now()
ParseDateTime(
date-time-string
[,
pop-conversion
] )
Quarter(
date
)
Second(
date
)
Week(
date
)
Year(
date
)