Date Format Conversion in Linq

[Shyam_Pragash]

Hi,

i try to convert the date format using Linq. i have n no. of rows and columns… in that datatable have Date columns… The Date columns format have to change …

Input:

dd-MM-yyyy

Expected Output
yyyy-MM-dd
yyyy-MM-dd
yyyy-MM-dd

Without losing other data…in the datatable…

Thanks
Shyam

[Sanjit_Pal1 (Sanjit Pal)]

Hey @Shyam_Pragash,

Have a look on the below thread, this might be helpful.

Convert datatable strings column to datetime

I am find the problem. i choose C# type when create project , solved this problem before change type to VB

Thanks,
Sanjit

[nikhil.girish]

Hi @Shyam_Pragash

kindly refer this post

Convert datatable strings column to datetime

@Angelo_Savino In General the LINQ Syntax should/could look like following (From row In Compressed2.AsEnumerable Let dt= DateTime.ParseExact(row.Item(“Column2”).ToString,“dd/MM/yy”,Globalization.CultureInfo.InvariantCulture) Select row).CopyToDataTable AsEnumerable is used for bringing the rows into an enumerable sequence There is no need to parseString into datetime (ParseExact Method) and then convert a datetime into a dateTime (Conver.toDate) But this statement will not do any changes.…

Thanks

[Manish540 (Manish Shettigar)]

Hi @Shyam_Pragash ,

Check this below workflow attached:-
DateConversion_To_SpecifiedFormat.xaml (10.0 KB)

Hope this may help you

[postwick (Paul Ostwick)]

Datetimes don’t have a format. Are the columns actually datetime or are they string?

And why Linq when you can just use a For Each Row and Assign? Simpler to code, simpler to interpret later.

[Sanjana1 (Sanjana)]

Because sometimes I need to understand the linq also as well if you can tell me then please tell me how to filter date format like - (02-december-2022), using linq ?
Thanks,
sanjana.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Sanjana1
Welcome to UiPath community

’ ’ ’ DT.AsEnumerable.Where(Function(x)CDate(x(“Date”).ToString). Date= CDate(“02-december-2022”).Date) ’ ’ ’