try this DT_Pre_Allegro.Select ("[Price Date] like ‘%" + Now.ToString (“MM / yyyy”) + "%’"). CopyToDataTable (), but it copies wrong data to me.
@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 :
@CMNV Are there No Column Headers present
Yes, Try with filter data activity, but the filter did not work
If the file has a column, but I wanted to show more current data
@CMNV Can you tell me What is the Column Name of Date Column ?
@CMNV Have you Checked this ?
I have tried.Its working… May be format issue with your excel. Try changing the format to text and check once
well, try this :
Function(x) CDate(x(“Fecha Precio”)).ToString(“yyyy-MM-dd”).Contains( Now.ToString(“yyyy-MM”) )
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.