Date Scraping

Help
1

one of the data that I want to scrap is the date data. I am fine with scraping eg 12/12/2012 dates, but when i scrap single digit date, such as 06/09/2012, it will be appended onto excel as 9/6/2012. This will give me a problem when I want to run this “DateTime.ParseExact(edate, “dd/MM/yyyy”, CultureInfo.InvariantCulture)”. Any suggestions or ideas on this?

2

Hi,
How about this.
go to excel and format your cell as per the expected date format.

3

Hello, I’ve tried this method and it doesnt work as the day and month were already swapped when we scrapped the data out. Hence, it is still an error.

4

If patter remains same for all the single digit dates then why don’t you swap the date and month.

6

The pattern does not remain for all the data. Let me show you in graphics what is the problem that i am facing, maybe it will help us better understand.

I am not getting why only for single-digit dates the format is not consistent.

2 Likes
8

Hi
I use add column row and on data array, I used this
{name,Dob.ToString(“dd/MM/yyyy”)}
and it works.
Thanks
Hung