Convert date from orchestrator to short date in excel

[adrian_sullivan]

i am getting the status of a job that is running in orchestrator and then and then i need to conver the long date that the job started on to a short date so as i can display what passed an failed on that day.

all i care about is pass \ fail so i have removed any retried entries
when i convert to a short dare ( currently uk date format dd/mm/yyyy) it looks good in excel when i export it out.

however when i filter on the dates in excel i can see that the for mat is all wrong

any help appreciated

the source is Source.xlsx
Source.xlsx (22.3 KB)

the output is Output.xlsx
Output.xlsx (16.9 KB)

the job is
Main.xaml (15.4 KB)

the end result should look like this

thanks

[Anil_G (Anil Gorthi)]

@adrian_sullivan

if you want to change on excel use format cells activity

cheers

[adrian_sullivan]

that worked for me.

i did have to get rid the step where i tried to correct the short date using
Convert.ToDateTime(Longdate).ToString(“dd-MM-yyyy”)

then just copied \ update row long date into short date

then format cells

thanks for the help

[adrian_sullivan]

i checked again and it does not work. it displays correctly but the timestamp is still present which i need to remove