Why date is getting wrong

[Bhargavi_Lokapur1 (Bhargavi Lokapur)]

when i was download the excel data from website in that date was coreect but when was read all data to another sheet of excel but its showing wrong data how can i solve this please help

[devasyasingh]

@Bhargavi_Lokapur1 could you send the snip of 2nd sheet/output?

[Palaniyappan (Forum Leader)]

Hi

While reading the excel file make sure PRESERVE FORMAT is enabled so that the format is retained
This usually happens when excel file is read and date format changes because of the column format

Have a view on this thread for more insights

Date and month interchanged while reading from excel

Hi all, I have an excel which i have to download from a website and then performance some calculation. While reading the date column from excel, the date read by the bot has interchanged date and month. For example, the date in the excel was “07-11-2022” Ie the date is 7th of October, 2022. But while i passed the same value in message box the date came out to be “11-07-2022” Ie 11th of july 2022. The date and month got interchanged. Please suggest how i can get the date correctly as in excel.

Cheers @Bhargavi_Lokapur1

[Bhargavi_Lokapur1 (Bhargavi Lokapur)]

I check its also not working
Please anyone suggest???

[Kartheek_Battu]

Hello @Bhargavi_Lokapur1

Assuming you have downloaded the data into a DataTable called ‘downloadedData’

Data Cleanup and Type Correction (Example: Removing leading/trailing spaces)

For Each row In downloadedData.Rows
row(“ColumnName”) = row(“ColumnName”).ToString.Trim
Next

Write the cleaned data to a new Excel sheet
Excel Application Scope:

• Use Excel activities to create a new Excel sheet or overwrite an existing one with the cleaned data.
• Use the “Write Range” activity to write the DataTable to the Excel sheet.

Thanks & Cheers!!!