It sounds like you’re trying to scrape an excel sheet for the dates, is that correct?
It sounds like you’re doing it correctly, likely doing a read range, grabbing all of the data out and exporting it to a datatable, and then for each row to check it. When you get data out of an excel sheet, the problem is that it doesn’t know that a date is a date, it thinks it’s just a normal string. You will have to parse the string in order to convert to a datetime object or simply to get out the month if that’s all you need.
As a way to figure it out, I would suggest creating a new sequence and assign one of the string dates to a variable and try parsing just the one without dealing with the excel sheet. That way you can ensure that you’re able to process dates how you’d expect and you can then use what you learned in your automation.
Edit: I would suggest trying to figure it out on your own and reading up on VB’s DateTime object, but, if you just want the answer, here’s a sample of a way to do it: Test_StringToDate.xaml (4.8 KB)