Get CSV Text as Collection Issue

V

vmaneesh

Member
Hello - I am trying to get the CSV values into a collection. However, when there is a date item for ex: '5/5/2018' - when it is converted into a collection it is having a text value like '28170'. If the date value in excel is 05/05/2018 - then it is properly being read. How can we solve this issue? Is there a way to format the entire column in excel itself by blueprism or how can we convert that text value into a date value?

Thanks in advance.
 
You must log in or register to reply here.
Top