How i can filter excel with all data current month?

[CMNV (Claudio Navarrete)]

try this DT_Pre_Allegro.Select (“[Price Date] like '%” + Now.ToString (“MM / yyyy”) + “%'”). CopyToDataTable (), but it copies wrong data to me.

[supermanPunch (Arpan)]

@CMNV Can you show us the Format of the date in the DT_Pre_Allergo datatable, So that we can use that format to get the date you want.

To check the format, you can just use a Message box with the value :
DT_Pre_Allergo(0)(“yourDateColumnName”).ToString

[CMNV (Claudio Navarrete)]

here an image of the excel data

[supermanPunch (Arpan)]

@CMNV Are there No Column Headers present

[Sriharisai_Vasi]

Did you try with filter data table activity and use contains filter?

[CMNV (Claudio Navarrete)]

Hi!,
Yes, Try with filter data activity, but the filter did not work

[CMNV (Claudio Navarrete)]

If the file has a column, but I wanted to show more current data

[supermanPunch (Arpan)]

@CMNV Can you tell me What is the Column Name of Date Column ?

[supermanPunch (Arpan)]

@supermanPunch

To check the format, you can just use a Message box with the value :
DT_Pre_Allergo(0)(“yourDateColumnName”).ToString

@CMNV Have you Checked this ?

[Sriharisai_Vasi]

I have tried.Its working… May be format issue with your excel. Try changing the format to text and check once

[CMNV (Claudio Navarrete)]

well, try this :

DT_Pre_Allegro.Rows.Cast(Of DataRow).Where(
Function(x) CDate(x(“Fecha Precio”)).ToString(“yyyy-MM-dd”).Contains( Now.ToString(“yyyy-MM”) )
).CopyToDatatable