|
| |
DateAdd(interval,number,date) |
Adds the time interval to date. The interval argument accepts the following values:
| Interval: |
Description: |
| yyyy |
Year |
| q |
Quarter |
| m |
Month |
| y |
Day of year |
| d |
Day |
| w |
Weekday |
| ww |
Week of year |
| h |
Hour |
| n |
Minute |
| s |
Second |
| Before: |
Code: |
After: |
| 17.02.01 |
DateAdd("yyyy","1",date) |
17.02.02 |
| 17.02.01 |
DateAdd("m","1",date) |
17.03.01 |
| 17.02.01 |
DateAdd("q","1",date) |
17.05.01 |
Related functions:
Date, DateDiff, DatePart, DateSerial, DateValue, Day, Month, MonthName, Now, Weekday, WeekDayName, Year
|
| View All Functions A-Z |
|
| |
|
