How to sort a Datatable by date?

Help Studio
, , ,
1

Hello
I have a date in this format
Screenshot_5
I need to save only those dates that fall within the next 16 days from today’s date

Example
Screenshot_6

thanks for your help

2

I need to save only those dates that fall within the next 16 days from today’s date

3

Use this in filter datatable Convert.ToDateTime(“ColumnName”)<datetime.now.adddays(16).

You might want to take care of exceptional handling while using the Convert.ToDateTime

4

image
@Sriharisai_Vasi, error - column type is not supported

5

sry please remove convert.todatetime in column name

6

Hey @Aibek_Abubakirov

The Column Value should be present inside double quotes and don’t convert it.
from your input file i can see there is no Header value.
if you are using Read Range activity to get data from excel then Uncheck the AddHeaders option.

if you uncheck AddHeaders Uipath will automatically add column names like Column0, Column1.

in your case as it is first column then it will be Column0.

“Column0” < datetime.now.adddays(16).

let me know if you need any help on this.

Regards,
Vijay.

7

image
image802×466 16.9 KB

I used this sort, but finds nothing

8

I used this sort, but finds nothing

How to sort a Datatable by date?

9

@Aibek_Abubakirov
Find a demo xaml here for starter Help
Aibek_Abubakirov.xaml (6.5 KB)

1 Like
10

@Aibek_Abubakirov
Find a demo xaml here for starter Help
Aibek_Abubakirov.xaml (6.5 KB)

Well done. thanks a lot @ppr

But what about when such a date is not on the list?

It turns out an error when there is no date of 16 days

11

@Aibek_Abubakirov
IT was Just about fast prototyping. In Case of No rows will be returned the CopyToDataTable throws an exception. Use instead of CopyToDataTable a ToList Statement this will Return alist of datarows. Now you can check the Count and If rows are returned then you can execute the CopyToDataTable

1 Like
12

@ppr I didn’t understand, could you explain in a bit more detail?

13

@Aibek_Abubakirov

grafik
grafik760×605 18.4 KB

Aibek_Abubakirov_V2.xaml (7.4 KB)

1 Like
14

@ppr checked your XAML file(V2), but the result returned nothing

15

@Aibek_Abubakirov
please send your testdata Excel or Values, so I can check at my end

1 Like
16

@ppr This can be done in the Filter Data Table?

17

@Aibek_Abubakirov
As we are Close to completion and my Testdates are running without exceptions so checking IT with your Testdata will Bring Out fast a Resolution. Please Provide Testdata or Sample values, thanks

1 Like
18

@ppr
Error.txt (2.1 KB) Screenshot_3

Test.zip (35.0 KB)

19

@Aibek_Abubakirov
was just a trim / additional spaces issue. Now its running
grafik

Just change to

(From d In dtData
Let dt = DateTime.ParseExact(d(0).toString.trim,“dd.MM.yyyy”, CultureInfo.InvariantCulture)
Where dt >= Now And dt <= Now.AddDays(16)
Order By dt
Select d).toList

2 Likes
21

@ppr @Vijay_Kumar_C @Sriharisai_Vasi

Error - CultureInfo is not declared

I tried installing System.Globalization.CultureInfo packages, but they do not install