Web Page File

Question

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.

Gaurav_Dhama_ · Answer

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.

Date Format Macro.yxmc

caltang · Answer

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

ForVicky92_Dates.yxmd

Vicky92 · Answer

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.

Date Check.xlsx