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
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:
Hope it helps!!
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)
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?
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,
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
