DateAdd

Description

Returns a date to which a time interval has been added.

Syntax


DateAdd(datepart, number, date)

Parameters

Parameter

Description

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; negative to get dates in the past).

date
Date/time object in the range 100 AD-9999 AD. Year values 0-29 are interpreted as 21^st century dates. Year values 30-99 are interpreted as 20^th century dates.

Parameter	Description
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; negative to get dates in the past).
date	Date/time object in the range 100 AD-9999 AD. Year values 0-29 are interpreted as 21^st century dates. Year values 30-99 are interpreted as 20^th century dates.

Usage

The datepart specifiers "y," "d," and "w" perform the same function add a number of days to a date.

When passing a date/time value as a string, enclose it in quotes. Otherwise, it is interpreted as a number representation of a date/time object.

Example

<!--- This example shows the use of DateAdd --->

...

<cfquery name = "GetMessages" datasource = "cfsnippets">

SELECT UserName, Subject, Posted

FROM Messages

</cfquery>



<P>This example uses DateAdd to determine when a message in

the database will expire. (The value selected is messages older

than <cfoutput>#value#



<cfswitch expression = #type#>

  <cfcase value = "yyyy">years</cfcase>

  <cfcase value = "q">quarters</cfcase>

  <cfcase value = "m">months</cfcase>

  <cfcase value = "y">days of year</cfcase>  

  <cfcase value = "w">weekdays</cfcase>  

  <cfcase value = "ww">weeks</cfcase>  

  <cfcase value = "h">hours</cfcase>  

  <cfcase value = "n">minutes</cfcase>  

  <cfcase value = "s">seconds</cfcase>    

  <CFDEFAULTCASE>years</CFDEFAULTCASE>

</cfswitch>

</cfoutput>).



<TABLE>

<TR>

  <TD>UserName</TD>

  <TD>Subject</TD>

  <TD>Posted</TD>

</TR>

<cfoutput query = "GetMessages">

<TR>

  <TD>#UserName#</TD>

  <TD>#Subject#</TD>

  <TD>#Posted# <cfif DateAdd(type, value, 

    posted) LT Now()>EXPIRED</cfif></TD>

</TR>

</cfoutput>

</TABLE>