Write collection gives ##### for dates

[absak]

Hello,

I'm having a trouble with write dates from collection, it gives ##### in the sheet then when i refresh the TCD it does not give values, what is the problem?

 

[nickbell123]

Hello,

I'm having a trouble with write dates from collection, it gives ##### in the sheet then when i refresh the TCD it does not give values, what is the problem?

Are you writing from a collection to an Excel sheet? Can you share screenshots of the excel sheet and the Blue Prism action?

Have you tried changing the number format of the column in Excel? What are the date formats of the values in the collection before you write it in? Try experimenting with different formats in the collection before you write.