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.Reflection System.Runtime.InteropServices System.Globalization System.Collections.ObjectModel System.Activities.DynamicUpdate System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities UiPath.DataTableUtilities GlobalVariablesNamespace GlobalConstantsNamespace 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 UiPath.Studio.Constants UiPath.System.Activities.Design System.Reflection.Metadata System.Memory System.Runtime.InteropServices.RuntimeInformation Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition System.ServiceModel NPOI UiPath.Python UiPath.Excel System.Runtime.Serialization UiPath.Excel.Activities.Design UiPath.Excel.Activities System.Data.SqlClient System.Data.Common System.ComponentModel.EventBasedAsync System.ComponentModel.TypeConverter System.Private.CoreLib Microsoft.Win32.Primitives System.ComponentModel System.ComponentModel.Primitives System.ObjectModel System.Memory.Data System.Console System.Configuration.ConfigurationManager System.Security.Permissions System.Private.Uri System.Private.Xml UiPath.Workflow System.Linq.Expressions System.Linq.Parallel System.Collections.Immutable System.Linq System.Linq.Queryable System.Private.ServiceModel System.Collections True True [yourString] 13.02.2023 False False True True True False False True False False True False False False True [GetMonth] [DateTime.ParseExact(yourString,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM")] [Getyear] [DateTime.ParseExact(yourString,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy")] [GetDate] [DateTime.ParseExact(yourString,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd")] False False True True True True False False True False True False False False [Date1] [now.AddDays(-7).Date] [arr_date] [Enumerable.Range(0,8).Select(Function(i) date1.AddDays(i)).ToArray()] [DT_Clone] [arr_date.Select(Function(d) dt_1.Clone.LoadDataRow({d.ToString("dd.MM.yyyy")},False)).CopyToDataTable()] [DT_Final] [DT_1.AsEnumerable.where(function(x) DT_Clone.AsEnumerable.any(function(y) x("Date1").ToString.Equals(y("Date1").ToString))).CopyToDataTable]