Answered

PAD is changing my date format

(0) Share

Report

Posted on by carcmena99

So im trying to build a RPA that opens a file that has been downloaded before. It works perfect but something that is strange is that when I manually open the excel file the date column stays the same (dd/MM/YYYY) and when I run the PAD it changes the date to MM/dd/YYYY, and it stays like this even if I change the format in excel, so the Month is now the Day. Can anyone help me with this?

Before:

After running the RPA:

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@carcmena99
When you open Excel, are the dates displayed in date format, General, or another format?

That format is vary when excel is opened by bot? Have you noticed any changes there?

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @carcmena99

i do think this may be a excel issue, one thing to know , when you input the details to excel using PAD, does it ensures it write the date format is in dd/MM/yyyy (based on datatable values) ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
carovh07 11 on at

Like (0)

Report
Copy link

Link copied!

Hello! Reading about the situation with dates, I'm also an RPA developer and use PAD. When I've wanted to work with Excel, the date format changes when using the Write to Excel Worksheet instruction.
Despite trying all the previously mentioned solutions, nothing worked.
Finally, I decided to use the instructions that allow creating a data table. This way, it's possible to retrieve and write Excel data without losing the date format.
I've attached an example image of what was done. (It might be a bit more complex, but it works to maintain the desired date format.)

I hope it is helpful

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @carcmena99 ,

Just check with system Date format. Then change it to the required Format.

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@carcmena99 and @carovh07
I've observed numerous cases where date format issues arise due to the system date format itself. Typically, all dates in Excel adhere to the system date format. Therefore, try adjusting your date format accordingly on your system.

If the issue persists, you may want to consider using a macro script to address this issue. This technique has proven effective for many individuals thus far.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No