Copy date and change format dd.mm.yyyy

[sullivanne]

Hello, my robot is supposed to copy the date from Excel and paste it into the application. The format in Excel is: dd.mm.yyyy, but after pasting into the application, the format automatically changes to d/mm/yyyy - I added the sequence:

DateTime.ParseExact(CurrentRow(“column name”).ToString,“M/dd/ yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

The robot enters the first date correctly, but when going to the second row, an error appears that the robot does not recognize the date d/mm/yyyy. How can I make the robot go through each rows, copy the date and paste it in the dd.mm.yyyy format?

Thank You!

[ppr (Peter Preuss)]

have a look at the following firstAid and verify the formats

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", CultureInf…

Later in the firstAid a strategy to fix it is demonstrated

Kindly note: ensure that no empty string will be parsed

[ppr (Peter Preuss)]

Also have a look here:

@sullivanne

CurrentRow(“column name”).ToString,“M/dd/ yyyy”,

@sullivanne

The format in Excel is: dd.mm.yyyy,

@sullivanne

robot does not recognize the date d/mm/yyyy.

within the description there are several inconsitencies mentioned related to the formats

[postwick (Paul Ostwick)]

@sullivanne

DateTime.ParseExact(CurrentRow(“column name”).ToString,“M/dd/ yyyy”,

The format you provide here is the format of the string you’re converting, not what you want it to be converted into. You have to be very careful about extra spaces like you have before yyyy. If the source is dd.mm.yyyy then that’s what you put here: DateTime.ParseExact(CurrentRow(“column name”).ToString,“dd.MM.yyyy”,

Note that you have to use MM not mm. MM is months, mm is minutes.

[Shiva_Nikhil]

@sullivanne

before reading the excel file can you try with this

!

in the range you can mention your column Range

cheers

[Gokul001 (Gokul Balaji)]

Hi @sullivanne

You can try with date expression

DateTime.ParseExact(CurrentRow(“column name”).ToString.Trim,{"MM/dd/yyyy","M/dd/yyyy","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy")

You can update the DATE FORMAT in the above expression : {"MM/dd/yyyy","M/dd/yyyy","dd.MM.yyyy"}

Regards
Gokul

[sullivanne]

@Gokul001

DateTime.ParseExact(CurrentRow(“column name”).ToString.Trim,{"MM/dd/yyyy","M/dd/yyyy","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy")

Unfortunately, it does not work, I have this error, after entering the date from the second row. The first row typed correctly.

[Gokul001 (Gokul Balaji)]

@Gokul001

,{"MM/dd/yyyy","M/dd/yyyy","dd.MM.yyyy"}

Have you add the necessary Date Format in the above expression? @sullivanne

DateTime.ParseExact(CurrentRow(“column name”).ToString.Trim,{"MM/dd/yyyy","M/dd/yyyy","d/M/yyyy","M/d/yyyy","dd/M/yyyy","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy")

[raju_alakuntla]

Hi @sullivanne ,

I think the dd and MM are in single digit. So the robot can not able identify which is date and which is month.

Regards,

[sullivanne]

I’m doing something wrong

[sullivanne]

Do you have any idea what I can do?

[Gokul001 (Gokul Balaji)]

Hi @sullivanne

Update the Double quotes in the expression that you have placed in the Type into activity

DateTime.ParseExact(CurrentRow("column name").ToString.Trim,{"MM/dd/yyyy","M/dd/yyyy","d/M/yyyy","M/d/yyyy","dd/M/yyyy","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy")

[sullivanne]

@Gokul001

DateTime.ParseExact(CurrentRow("column name").ToString.Trim,{"MM/dd/yyyy","M/dd/yyyy","d/M/yyyy","M/d/yyyy","dd/M/yyyy","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy")

Thank you for helping me so much. The robot enters the date - from the first row correctly, from the second row instead of dd.MM.yyyy entered MM.dd.yyyy - dates in excel are entered in the same way. What could be the cause?

[Gokul001 (Gokul Balaji)]

@Gokul001

Update the Double quotes in the expression that you have placed in the Type into activity

DateTime.ParseExact(CurrentRow("column name").ToString.Trim,{"MM/dd/yyyy","M/dd/yyyy","d/M/yyyy","M/d/yyyy","dd/M/yyyy","d

Use this expression to update the date for all the colums. Can you share the sample excel file?

Or else

you can try with Format cell activity

After that Use read range activity

Regards
Gokul

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @sullivanne ,
You can use

some case when we type into website, this text field change format of string you can use hot key and set a clipboard,
hope it help
regards,

[kmisko11 (Kamil Misko)]

@sullivanne

I think it would be better to share at least the screenshot of your workflow so we all can see how you build it I suppose the solution is easy and there might just small mistake in the workflow.

Regards,
Kamil