Hi, I have an excelsheet with dates in Column A and different values in Column B. I need to bring back the value from a picked date. Picked date is stored in a DateTime Variable. I want to get the value from picked date in a new variable. Any suggestions?
@ringan Try select statement on datatable after reading excel.
String Output = dt.Select(“[ColumnA Name]='”+datevaraiable+“'”)(0)(1).tostring
Where dt is datatable which contains excel data.
You also need to check the date format in excel after reading.
3 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.