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()]