Date format changing issue_021

[Gokul_Murali]

Hello guys
Iam reading an excel contains date

so while RPA run the format got changed, i used preserved format in the read range activity as well but not working.

does anyone have any idea.

[Swakatha_Meenakshi_Suresh (Swakatha Suresh)]

Can you please try the Modern Read Range Activity and set Read Formatting to Display Value ?

[Yoichi]

Hi,

Can you try the following expression?

CDate(Row("ServiceDate")).ToString("dd/MM/yyyy")

Regards,

[Gokul_Murali]

@Yoichi
This expression only valid for the format that is mentioned in the expression right.

but sometime it will contain only numbers as i showed in the picture.

[Yoichi]

How about the following expression?

if (Double.TryParse(Row("ServiceDate").ToString,New Double),DateTime.FromOADate(CDbl(Row("ServiceDate").ToString)).ToString("dd/MM/yyyy"),CDate(Row("ServiceDate")).ToString("dd/MM/yyyy"))

Regards,

[Gokul_Murali]

its not working

[Yoichi]

Hi,

Is there any error message?

Regards,

[Gokul_Murali]

its not showing any error

[Yoichi]

Hi,

If possible can you share your worksheet? It’s no problem dummy data if we can reproduce the matter.

Regards,