<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="../../style.css">
<title>
Gambas Documentation - DateAdd
</title>
</head>
<body>
<table class="none" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td align="left">
<font size="-1">
<a href="../../help%3Fen"><img class="flag" alt="Home" border="0" src="../../img/lang/en.png" align="center"></a>&nbsp;&nbsp;
<a href="../lang%3Fen">Up</a>&nbsp;&nbsp;
<a href="date%3Fen">Previous</a>&nbsp;&nbsp;
<a href="datediff%3Fen">Next</a>&nbsp;&nbsp;
</td></tr></table>
<div class="notab">
<h1>
DateAdd
</h1>
<div class="black"><font color="white" size="-2"><b>Syntax</b></font></div>
<pre class="syntax"><u>Result</u> = <b>DateAdd (</b> <u>Date</u> as Date <b>,</b> <u>Period</u> AS Integer <b>,</b> <u>Count</u> AS Integer <b>)</b> AS Date</pre><p>

Add a specific period to a given date.
<p>
<ul>
<li><u>Date</u> is the initial date.
<li><u>Period</u> is the kind of period: year, month, day, week...
<li><u>Count</u> is the number of periods to add.
<p>
</ul>

The resulting date is returned.
<p>
<u>Period</u> can be one of the following constants:
<p>
<table class="table" border="0" bordercolor="#000000" cellpadding="4" cellspacing="0">
<tr><th>
Constant
</th><th>
Effect
</th></tr>
<tr bgcolor="white"><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/second%3Fen">Second</a></tt>
</td><td valign="top">
Adds seconds.
</td></tr>
<tr><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/minute%3Fen">Minute</a></tt>
</td><td valign="top">
Adds minutes.
</td></tr>
<tr bgcolor="white"><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/hour%3Fen">Hour</a></tt>
</td><td valign="top">
Adds hours.
</td></tr>
<tr><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/day%3Fen">Day</a></tt>
</td><td valign="top">
Adds days.
</td></tr>
<tr bgcolor="white"><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/week%3Fen">Week</a></tt>
</td><td valign="top">
Adds weeks.
</td></tr>
<tr><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/weekday%3Fen">WeekDay</a></tt>
</td><td valign="top">
Adds week days (ignore Saturday and Sunday).
</td></tr>
<tr bgcolor="white"><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/month%3Fen">Month</a></tt>
</td><td valign="top">
Adds months.
</td></tr>
<tr><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/quarter%3Fen">Quarter</a></tt>
</td><td valign="top">
Adds quarters.
</td></tr>
<tr bgcolor="white"><td valign="top">
<tt><a href="../comp/gb/gb%3Fen">gb</a>.<a href="../comp/gb/gb/year%3Fen">Year</a></tt>
</td><td valign="top">
Adds years.
</td></tr>
</table>
<p>
<div class="gray"><font color="white" size="-2"><b>Example</b></font></div>
<pre class="example">date1 = Date(1972, 09, 06, 1, 45, 0)
date2 = DateAdd(date1, gb.Minute, 45)
PRINT date1, date2
<hr>06.09.1972 01:45:00	06.09.1972 02:30:00</pre>
<p>
<hr><b>See also</b><br>
<a href="../cat/time%3Fen">Date &amp; Time Functions</a>&nbsp;&nbsp;

</div>
<hr>
</body>
</html>

