Report from orchestrator

Hi There,

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
image

Hi @sangeethaneelavannan1

Use Format Cells activity and bring the date fromat into a common one like MM/dd/yyyy and filter the excel.

Hope it helps!!

@Parvathy
Thanks for the reply.I have done that and could not format the cells.The above screenshot is after formatting to MM/dd/yyyy.

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:



Output:

Hope it helps!!

I have downloaded the excel and manually formatting the cell,it is not working.

@sangeethaneelavannan1

Keep the option in Custom and give the format MM/dd/yyyy.

Regards,

@Parvathy

still not working

@sangeethaneelavannan1

It’s working in my case. Please send the sample excel file so that I will help you with the code.

Regards

Here you go
sample.xlsx (10.4 KB)

@sangeethaneelavannan1

use assign activity and assign the below syntax to a variable

CurrentRow("Started").ToString.Split(" ")(0)

Hope it helps!!

@Anil_G could you please have a look on this?

@sangeethaneelavannan1

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

DateTime.ParseExact(Strinput.ToString, {"MM/dd/yyyy","MM/dd/yyyy hh:mm:ss"}, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None)

Cheers

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.

Thanks,

@sangeethaneelavannan1

Can you check if there are any spaces at the start of the strings in few lines…

Also how are you writing the data?

Cheers

No spaces in front of the strings.I have exported the csv file from orchestrator queue page
image