DateTime.Now.AddYears(Years)
.AddYears(Years) adds the specified number of years to the DateTime object. To subtract years, simply supply the Years parameter with a negative number.
Note: the AddYears() method adds the years to the date or variable calling it. You cannot do something like this:
var ldToday = DateTime.Today;
var ldNextYear = ldToday.AddYears(1);
ldToday will be the same as ldNextYear.
Applies To
- Convert.ToDateTime(Convert)
- DateTime.Now
- DateTime.Today
- Event.Form.MainGrid.Results.AddRow([IDColumn]).GetDateTime(Column)
- Event.Form.MainGrid.Results.GetMaximumDateTime(ColName)
- Event.Form.MainGrid.Results.GetMinimumDateTime(ColName)
- Event.Form.MainGrid.Results.GetRow(X).GetDateTime(Column)
- Event.Form.MainGrid.SelectedRow.GetDateTime(Column)
- Event.Form.Parent.MainGrid.Results.AddRow([IDColumn]).GetDateTime(Column)
- Event.Form.Parent.MainGrid.Results.GetMaximumDateTime(ColName)
- Event.Form.Parent.MainGrid.Results.GetMinimumDateTime(ColName)
- Event.Form.Parent.MainGrid.Results.GetRow(X).GetDateTime(Column)
- Event.Form.Parent.MainGrid.SelectedRow.GetDateTime(Column)
- Event.Form.Parent.GetDataTable([TableName]).AddRow([IDColumn]).GetDateTime(Column)
- Event.Form.Parent.GetDataTable([TableName]).GetMaximumDateTime(ColName)
- Event.Form.Parent.GetDataTable([TableName]).GetMinimumDateTime(ColName)
- Event.Form.Parent.GetDataTable([TableName]).GetRow(X).GetDateTime(Column)
- Event.Form.Parent.Grids(FID).Results.AddRow([IDColumn]).GetDateTime(Column)
- Event.Form.Parent.Grids(FID).Results.GetMaximumDateTime(ColName)
- Event.Form.Parent.Grids(FID).Results.GetMinimumDateTime(ColName)
- Event.Form.Parent.Grids(FID).Results.GetRow(X).GetDateTime(Column)
- Event.Form.Parent.Grids(FID).SelectedRow.GetDateTime(Column)
- Event.Form.GetDataTable([TableName]).AddRow([IDColumn]).GetDateTime(Column)
- Event.Form.GetDataTable([TableName]).GetMaximumDateTime(ColName)
- Event.Form.GetDataTable([TableName]).GetMinimumDateTime(ColName)
- Event.Form.GetDataTable([TableName]).GetRow(X).GetDateTime(Column)
- Event.Form.Grids(FID).Results.AddRow([IDColumn]).GetDateTime(Column)
- Event.Form.Grids(FID).Results.GetMaximumDateTime(ColName)
- Event.Form.Grids(FID).Results.GetMinimumDateTime(ColName)
- Event.Form.Grids(FID).Results.GetRow(X).GetDateTime(Column)
- Event.Form.Grids(FID).SelectedRow.GetDateTime(Column)
- Inventory.LotExplosion(Lots[, View, EndDate, NegativeLots, ByProducts]).AddRow([IDColumn]).GetDateTime(Column)
- Inventory.LotExplosion(Lots[, View, EndDate, NegativeLots, ByProducts]).GetMaximumDateTime(ColName)
- Inventory.LotExplosion(Lots[, View, EndDate, NegativeLots, ByProducts]).GetMinimumDateTime(ColName)
- Inventory.LotExplosion(Lots[, View, EndDate, NegativeLots, ByProducts]).GetRow(X).GetDateTime(Column)
- InventoryLot.ExpirationDate
- InventoryLot.LotDate
- Parameters.Results.AddRow([IDColumn]).GetDateTime(Column)
- Parameters.Results.GetMaximumDateTime(ColName)
- Parameters.Results.GetMinimumDateTime(ColName)
- Parameters.Results.GetRow(X).GetDateTime(Column)
- Query.GetDateTime(Query[, IsNull])
- Query.GetTable(Query).AddRow([IDColumn]).GetDateTime(Column)
- Query.GetTable(Query).GetMaximumDateTime(ColName)
- Query.GetTable(Query).GetMinimumDateTime(ColName)
- Query.GetTable(Query).GetRow(X).GetDateTime(Column)
- Script.GetDataTable(TableName).AddRow([IDColumn]).GetDateTime(Column)
- Script.GetDataTable(TableName).GetMaximumDateTime(ColName)
- Script.GetDataTable(TableName).GetMinimumDateTime(ColName)
- Script.GetDataTable(TableName).GetRow(X).GetDateTime(Column)
Properties and Methods
None
Available
The .AddYears(Years) method is available in:
- 15.03.016
- All newer builds
Type
DateTime
Syntax
DateTime.Now.AddYears(Years);
Parameters
|
Parameter |
Required |
Description |
|---|---|---|
|
Years |
Yes |
An integer value. Can be positive or negative. Non-integers will generate a scripting error. |
Example
var ldNew = new DateTime('6/10/2021 12:34:56');
var ldNewA = new DateTime('6/10/2021 12:34:56').AddYears(1);
var ldNewB = new DateTime('6/10/2021 12:34:56').AddYears(10);
var ldNewC = new DateTime('6/10/2021 12:34:56').AddYears(100);
var ldNewD = new DateTime('6/10/2021 12:34:56').AddYears(1000);
var ldNewE = new DateTime('6/10/2021 12:34:56').AddYears(-10);
Event.Form.MessageBox('Add Years to ' + ldNew.ShortDateString + ':' +
'\n1 Year: ' + ldNewA.ShortDateString +
'\n10 Years: ' + ldNewB.ShortDateString +
'\n100 Years: ' + ldNewC.ShortDateString +
'\n1000 Years: ' + ldNewD.ShortDateString +
'\n-10 Years: ' + ldNewE.ShortDateString);
/* Expected prompt response:
Add Years to 06/10/2021:
1 Year: 06/10/2022
10 Years: 06/10/2031
100 Years: 06/10/2121
1000 Years: 06/10/3021
-10 Years: 06/10/2011
*/