Read the data as per the date and write that data in output

[Aregala_Yedukondalu]

I have excel it have much of data what my problem is read, only today data and store that data in output by using filter data table, please help me thanks

[aquinn]

Can you please provide a screenshot of the excel? as if there is a column containing the date you can use an IF statement

[Gokul001 (Gokul Balaji)]

Hi @Aregala_Yedukondalu

1. Use Read range activity → Store it in DT

2. Use Filter Data Table

3. Use Write Range activity

Regards
Gokul

[Aregala_Yedukondalu]

i tried this but it not writing the data in the excel

[Aregala_Yedukondalu]

Ok

[Gokul001 (Gokul Balaji)]

Hi @Aregala_Yedukondalu

How about this expression?

ExtractDataTable = DtInput.AsEnumerable.Where(Function(r) r("Column Name").ToString.Contains(DateTime.Now.ToString("dd-MM-yyyy"))).CopyToDataTable

Regards
Gokul

[Aregala_Yedukondalu]

Where i have to write this

[Gokul001 (Gokul Balaji)]

Hi @Aregala_Yedukondalu

You Assing activity and

LHS → DtOutput → Variable type is Datatable

RHS → DtInput.AsEnumerable.Where(Function(r) r(“Column Name”).ToString.Contains(DateTime.Now.ToString(“dd-MM-yyyy”))).CopyToDataTable

Regards
Gokul

[Aregala_Yedukondalu]

i tried this is also not working, i forgot to mention one thing, that is i am using C# sorry for this. Thanks…

[rohith.prabhu]

Hi @Aregala_Yedukondalu ,

Try the below expression & let me know if it helps.
Input_DT.AsEnumerable.Where(Function(x) CDate(x(“date”).ToString(“dd-MM-yyyy”).Equals(Now.ToString(“dd-MM-yyyy”)).CopyToDataTable()

You can reref the below post for more details on the same.

How to get the older dates than the current month

Hi @Marian_B , Could you Check the below Expression : Input_DT.AsEnumerable.Where(Function(x)CDate(x("Date").ToString).Month<Now.Month).ToArray Also you would need to follow the below Post to handle the Errors when you convert directly the Filtered Datarows into Datatable. There might be additional conditions that need to be added if there are multiple date formats/Empty values or change the CDate() to DateTime.ParseExact() to get the appropriate results. Let us know if the expression does…

Thanks,
Rohith

[Aregala_Yedukondalu]

@rohith.prabhu

Input_DT.AsEnumerable.Where(Function(x) CDate(x(“date”).ToString(“dd-MM-yyyy”).Equals(Now.ToString(“dd-MM-yyyy”)).CopyToDataTable()

Thank you for ur help but its not working

[ushu (Usha kiranmai)]

Hello @Aregala_Yedukondalu - If possible share a sample input excel

[Aregala_Yedukondalu]

@Aregala_Yedukondalu

Ok

[ppr (Peter Preuss)]

values visual in Excel are not mandatory in the same format within the datatable
In the following FirstAid sheet some analysis techniques are described:
[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Just run it and let us know the result / some outputs from the immediate panel.

Once the format / values within the datatable are cleared we can work further on the filter part

[ppr (Peter Preuss)]

keep in mind that this data will not have todays (11th Aug 2022) dates. So filter result is empty

[Aregala_Yedukondalu]

sorry @ppr that is old excel, i will post another excel please look into that

[ppr (Peter Preuss)]

no problem with the old excel. Just do the analysis as described in the FirstAid and let us know the results

[Aregala_Yedukondalu]

I tried first those all but i am facing issues, and i am using c#

[ppr (Peter Preuss)]

@Aregala_Yedukondalu

using c#

no problem as you can just use YourDataTableVar within the immediate panel and get insights to the content.