Convert date yyyy-mm-dd on dd-mm-yyyy

Help StudioX
,
1

Hi, I want my robot to convert the date from yyyy-mm-dd to dd-mm-yyyy. My robot goes through the lines in Excel and enters the dates in the app, but I wish it was in a different format.
How can I do this?

2

Hi @sullivanne

Try the below syntax:

strOutput = DateTime.ParseExact(strDate, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Regards

1 Like
3

@sullivanne,

Use Excel Process Scope and Use Excel File. Inside it use Format Cells activity and select the desired format.

Thanks,
Ashok :slight_smile: