FunctX XQuery Function Library > Dates, Times and Durations > Month >

functx:add-months

Adds months to a date

Description

The functx:add-months function adds a specified number of months to a date. The $date argument must be castable to xs:date, meaning that it must have the type xs:date or xs:dateTime, or be an xs:string or untyped value of the form YYYY-MM-DD.

Arguments and Return Type

XQuery Function Declaration

declare namespace functx = "http://www.functx.com";
declare function functx:add-months
  ( $date as xs:anyAtomicType? ,
    $months as xs:integer )  as xs:date? {

   xs:date($date) + functx:yearMonthDuration(0,$months)
 } ;

Examples

functx:add-months(xs:date('2004-01-23'),1)

2004-02-23

functx:add-months(
     xs:dateTime('2005-12-31T12:00:13'),2)

2006-02-28

functx:add-months('2005-12-31',-3)

2005-09-30

Depends On

See Also

History