https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76471#M28966 <STRONG>​Hi ,<BR /><BR /><BR /><BR />I hope it shouldn't&nbsp; write american date value. because it is writing exactly when I write 15/04/2021 why American date value is not working here ?;) <BR /><BR />when I am writing back I am using write collection stage ..<BR /></STRONG><BR /><BR />------------------------------<BR />Regards<BR />Manda Janaki Sekhar<BR /><BR />------------------------------<BR /> Thu, 11 Feb 2021 12:57:00 GMT Sekhar___ 2021-02-11T12:57:00Z https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76469#M28964 ​​Hi All ,<BR /><BR />I have a cell in workbook which has value 02/04/2021 when im reading the data through get collection stage my collection is filling with 02/04/2021 but when Im re writing back to excel through write collection stage it is writing as 04/02/2021 . To check again I filled the cell with value 15/04/2021 now get collection read as 15/04/2021 to collection and when I am re writing back to excel through write collection stage as 15/04/2021 which is correct. Now my issue why it is writing different format when I am writing 02/04/2021 to excel .<BR /><BR /><BR />Please help me to understand the issue ..<BR /><BR />Thanks<BR /><BR />------------------------------<BR />manda janaki sekhar<BR />Sr.Analyst<BR />Deutsche Bank Group<BR />Indian/Mauritius<BR />------------------------------<BR /> Thu, 11 Feb 2021 11:45:00 GMT https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76469#M28964 Sekhar___ 2021-02-11T11:45:00Z https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76470#M28965 Hi Manda<BR /><BR />This is a common issue with excel and its writing the date as an american date value. When you are writing the value to the cell are you using the excel set cell value action or the write collection action?<BR /><BR />------------------------------<BR />Michael ONeil<BR />Technical Lead developer<BR />Everis Consultancy<BR />Europe/London<BR />------------------------------<BR /> Thu, 11 Feb 2021 12:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76470#M28965 michaeloneil 2021-02-11T12:01:00Z https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76471#M28966 <STRONG>​Hi ,<BR /><BR /><BR /><BR />I hope it shouldn't&nbsp; write american date value. because it is writing exactly when I write 15/04/2021 why American date value is not working here ?;) <BR /><BR />when I am writing back I am using write collection stage ..<BR /></STRONG><BR /><BR />------------------------------<BR />Regards<BR />Manda Janaki Sekhar<BR /><BR />------------------------------<BR /> Thu, 11 Feb 2021 12:57:00 GMT https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76471#M28966 Sekhar___ 2021-02-11T12:57:00Z https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76472#M28967 This is usually a conversion issue between bp and excel which is why it ends up in american date value, you can see similar issues with dates in database etc. If you are using write collection then after it has been written you could try using the Format cell action in the excel object. Select the whole column to set it as "dd/MM/yyy".<BR /><BR />Hope this helps <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Michael ONeil<BR />Technical Lead developer<BR />Everis Consultancy<BR />Europe/London<BR />------------------------------<BR /> Thu, 11 Feb 2021 13:39:00 GMT https://community.blueprism.com/t5/Product-Forum/Write-to-Collection-Action/m-p/76472#M28967 michaeloneil 2021-02-11T13:39:00Z