I have downloaded the report from queue and tried to filter out the report based on started date but the date field has dynamic date format and could not filter out the report.I have tried to change the format of the column as well but still the date format is not changed to selected format for some cells.please help
In the fomat cells acitivty keep the option in custom and give the format MM/dd/yyyy. What ever may be the input format it will return only MM/dd/yyyy.
Refer the below image for better understanding.
Input:
Even if the date format looks different on excel …when you read it using read range activity and with raw value or preserve format unchecked…you would get in the same format across the sheet I believe can you please check the same…
Alternately … we can use parseexact to parse both types of dates as well if that is the case…but I would first suggest to check the date format when you read the excel into the datatable…use the locals panel to check the format
Hi @Anil_G
Thanks for the reply.
I am not looking for automation solution to format the cells.I have tried to do the manual formatting in the report using format cells option which was exported from orchestrator queue.Unfortunately,the formatting is not working for the started column.