HI,
I've been having a nightmare with this recently this is my problem:
When Power automate pulls dates from my excel sheet it pulls them through in the wrong way for example, if i wanted the date to be 08/04/2024 it would pull through as 04/08/2024.
What I've done to fix it:
1) Change the sheet local to GB for the dd/MM/yyyy format.
2) Use the ISO 8601 format on the puill rows command. this worked for a bit but it went back to the wrong style
3) Pull the dates through as serial numbers. I found out that PA was pulling the dates through as the american style serial number even after i changed the local to GB.
Could anyone please help?
Share
Report
All responses (
Answers (
522
