User Guide

Chapter 2: ColdFusion Functions 315
DateAdd
Returns a date to which a specified time interval has been added.
See also DateConvert, DatePart, and CreateTimeSpan.
Syntax DateAdd( datepart , number , date )
datepart
One of the following strings:
•
yyyy — Year
•
q — Quarter
•
m — Month
•
y — Day of year
•
d — Day
•
w — Weekday
•
ww — Week
•
h — Hour
•
n — Minute
•
s — Second
number
Number of units of datepart to add to date (positive to get dates in the future or
negative to get dates in the past).
date
Date/time object in the period from 100 AD to 9999 AD. Years from 0 to 29 are
interpreted as 21
st
century values. Years 30 to 99 are interpreted as 20
th
century
values.
Usage The datepart specifiers "y," "d," and "w" perform the same function — add a certain
number of days to a given date.
When passing a date/time value as a string, make sure it is enclosed in quotes.
Otherwise, it is interpreted as a number representation of a date/time object, returning
undesired results.
Examples <!--- This example shows the use of DateAdd --->
...
<CFQUERY NAME="GetMessages" DATASOURCE="cfsnippets">
SELECT UserName, Subject, Posted
FROM Messages
</CFQUERY>