So I created a separate variable known as PublishedDateColumn assigned with
> ExtractDataTable.AsEnumerable.Select(Function(r) r(0).ToString.Trim).ToArray
ExtractDataTable being the Data Table, I then used a
ForEach item in PublishedDateColumn
Using the if statement
PublishedDateColumn.Equals(Now.ToString("dd MMM yyyy"))
It would filter the data table removing all values which are not the current date.
The problem is that PublishedDateColumn when using message box is being outputted as System.String() so it will always go to the else statement.
Any help would be appreciated.