Home > lang > dateadd 
 en fr de es it nl pl pt pt_BR mk sq ca hu tr ar fa id vi ko ja ru zh zh_TW eo
Previous  Next  Edit  Rename  Undo  Search  Administration  
Documentation  
Warning! This page is not translated.  See english version 
DateAdd
Result = DateAdd ( Date as Date , Period AS Integer , Count AS Integer ) AS Date

Add a specific period to a given date.

The resulting date is returned.

Period can be one of the following constants:

Constant Effect
gb.Second Adds seconds.
gb.Minute Adds minutes.
gb.Hour Adds hours.
gb.Day Adds days.
gb.Week Adds weeks.
gb.WeekDay Adds week days (ignore Saturday and Sunday).
gb.Month Adds months.
gb.Quarter Adds quarters.
gb.Year Adds years.

Example

date1 = Date(1972, 09, 06, 1, 45, 0)
date2 = DateAdd(date1, gb.Minute, 45)
PRINT date1, date2

06.09.1972 01:45:00 06.09.1972 02:30:00

See also

Date & Time Functions