Web Page File

[Vicky92]

Hi Team,

I have downloaded the file from website. I have to use the same for my working.

Can you please help me to get the data in input format/usuable format.

While using the Input data, it showing the error as "

Error when Reading in .xls Files - Error opening connect string: Microsoft Access Database"

Attaching working file for refernce. 

[Vicky92]

Format coming as Web Page

[caltang]

This may help: https://knowledge.alteryx.com/index/s/article/Error-opening-connect-string-Microsoft-Access-Database...

These posts too:

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Error-when-Reading-in-xls-File...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Error-opening-connect-string-M... 

[KGT]

This sounds like the webpage has been saved, not a file downloaded from the webpage. The file has not attached and so I can't confirm.

Also, is there another format other than xls? Microsoft has not supported XLS for several years now, and so if there is another format available, then that will be better for you.

[Vicky92]

Hi Team, I want to convert different dates into one format of date.

File Uploaded for your your reference.

Kindly note that one column has different format of dates while the required output need only one format of date.

Also note that format of input date is currently "STRING". Request you to pls help with suitable formula.

[caltang]

Don't think your question is related to your main post, but I did something for you.

So far I have seen your scenarios laid out, but there are some scenarios which you need to flag out and test yourself. For instance, 09/08/2025 - is it 8th September 2025 or 9th August 2025? How can you tell from the date itself if it is not consistent?

You need a few more flags or data points to make that call. It is not straightforward to convert if you have scenarios like that @Vicky92 

[Gaurav_Dhama_]

Try this macro, I am using regex to identify the format and then format the dates accordingly. 

Note that it follows the hierarchy month-day-year > year-month-day> day-month-year

What this means is, if you have a date say 08-02-2025, it is going to pick 08 as month based on the hierarchy.