System.Activities
System.Activities.Statements
System.Activities.Expressions
System.Activities.Validation
System.Activities.XamlIntegration
Microsoft.VisualBasic
Microsoft.VisualBasic.Activities
System
System.Collections
System.Collections.Generic
System.Data
System.Diagnostics
System.Drawing
System.IO
System.Linq
System.Net.Mail
System.Xml
System.Xml.Linq
UiPath.Core
UiPath.Core.Activities
System.Windows.Markup
System.ComponentModel
System.Runtime.Serialization
System.Xml.Serialization
UiPath.Excel
UiPath.Excel.Activities
UiPath.DataTableUtilities
System.Collections.ObjectModel
System.Activities.DynamicUpdate
System.Globalization
UiPath.UIAutomationNext.Enums
UiPath.UIAutomationCore.Contracts
UiPath.UIAutomationNext.Activities
UiPath.Platform.ObjectLibrary
UiPath.Shared.Activities
System.Activities
Microsoft.VisualBasic
mscorlib
System.Data
System.Data.DataSetExtensions
System
System.Drawing
System.Core
System.Xml
System.Xml.Linq
PresentationFramework
WindowsBase
PresentationCore
System.Xaml
UiPath.System.Activities
UiPath.UiAutomation.Activities
System.Runtime.Serialization
UiPath.Excel
UiPath.Excel.Activities.Design
UiPath.Excel.Activities
UiPath.UIAutomationNext
UiPath.UIAutomationCore
UiPath.UIAutomationNext.Activities
UiPath.Platform
System.ServiceModel
Microsoft.Bcl.AsyncInterfaces
System.ValueTuple
System.ComponentModel.Composition
System.Memory
UiPath.GSuite.Activities.Design
UiPath.Word
System.Runtime.WindowsRuntime
System.Collections.Immutable
Microsoft.Extensions.DependencyModel
True
[dt_result]
[dt.Clone()]
[dt_result]
[(From row In dt.AsEnumerable()
Let firsthalf = Convert.ToDateTime(String.Format("{0} {1} {2}","01",row("MONTH START").ToString,(CInt(row("YEAR END").ToString)-1).ToString),New System.Globalization.CultureInfo("ro-RO"))
Let secondHalf = Convert.ToDateTime(String.Format("{0} {1} {2}","01",row("MONTH END").ToString,row("YEAR END").ToString),New System.Globalization.CultureInfo("ro-RO"))
Let range = Convert.ToInt32(Math.Abs(DateDiff(DateInterval.Month, secondHalf,firstHalf)))
Let months = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(String.Join(",",Enumerable.Range(0,range+1).Select(Function(s) (firsthalf.AddMonths(s).ToString("MMMM yyyy",New System.Globalization.CultureInfo("ro-RO"))))))
Let ra = New Object(){row("MONTH START"),row("YEAR START"),row("MONTH END"),row("YEAR END"),"",months}
Select dt_result.Rows.Add(ra)).CopyToDataTable()]