The correct form to paste Date with "Type Into"

studio
variable

#1

Hello everyone!

I need your help guys…

I need to paste a date with the tool “Type Into”, but when I try paste the date appears in format MM / dd / yyyy.

How I Can paste the date on format dd / MM / yyyy?

In Excel the date is all right.

date

Please help me!!!

Thank you!


#2

Hi @arthurfsantos11,

Refer this post

Regards,
Arivu


#3

Hello arivu96!

I would to thank you for the answer!

But, when I paste this code? You can send one printscreen for me please?


#4

Hi @arthurfsantos11,

use assign activity before using Type Into activity

dt_faturamento=DateTime.ParseExact(dt_faturamento.ToString(),"MM/dd/yyyy",Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards,
Arivu


#5

Hi @arivu96!

I tried with this code, however the system has presented error.

My sequence is:

  • Open the window where the code will be paste;

  • click on the box that the code will be paste;

  • Assign dt_faturamento = dt_faturamento=DateTime.ParseExact(dt_faturamento.ToString(),“MM/dd/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

  • Type into ‘TEditPlus’ - dt_faturamento

How I can resolve this problem?

Thank you for the patience!


#6

your input date format is “MM/dd/yyyy” ???
your expected date format is “dd/MM/yyyy”???
make sure you input should not empty.

if its not correct please correct it

please put Log message before converting the data

Regards,
Arivu


#7

My date on Excel is “dd/MM/yyyy” and the “Read Row” are reading this rows.

But when i will paste with “Type into”, on my system, appears on format “MM/dd/yyyy”,

excel


#8

before assigning put log message to print the value and check the format.

send screenshot

Regards,
Arivu


#9

here the screenshot.

the format is dd/MM/yyyy


#10

and here my excel sheet

dt_faturamento


#11

Hi @arthurfsantos11,

before converting date format use log message to print the value and check the date format what you are getting based on that apply in the code

Inputpattern :“dd/MM/yyyy”
outputpattern :“MM/dd/yyyy”
dt_faturamento=DateTime.ParseExact(dt_faturamento.ToString(),Inputpattern,Globalization.CultureInfo.InvariantCulture).ToString(outputpattern)

Regards,
Arivu


#12

Hello There,

Please have a look at screenshot below,

ConvertDate

let us know. whether above runs or not.

Thanks,
Pankaj


#13

hello @Pankaj.Patil, thanks for the support!

In the first assing “todayDate” is a var to use the date of current day, right?

However, I’m coping the date from an Excel Sheet. I’ll realy use the “todayDate”? Or my “todayDate” will be my var “dt_faturamento” ? That is the date I’m coping.


#14

@arivu96

If you can send me the screenshots that I can made i really can get sucess on my project.

Where I find this informations?

“Inputpattern” and “outpattern”?


#15

This is my project:

I need copy 1320 dates from an Excel sheet and paste on my system.

But when I’ll paste the date on my system, the date are is in format " MM/dd/yyyy ", however on my Excel sheet the format is dd/MM/yyyy e this is what I need.

Please help me.


#16

hello @arivu96.

How I’m new member, I can’t upload itens and sent more than 20 replies on day.

I creat another account for talk with you.


#17

@arthurfsantos11 @arthurfs11

  1. Add a write line activity after you read the value from Excel and look in the Output panel to see exactly what you are reading. Excel makes a big difference between what is displayed and what is really memorized in the sheet.
  2. Use Datetime.Parse instead of Date

#18

Hi @CorneliuN!

How I can use Datatime.Parse?


#19

HI @arthurfs11,

Use assign activity

dt_faturamento=Convert.ToDateTime(dt_faturamento).ToString("dd/MM/yyyy")

Regards,
Arivu


#20

Hi @arivu96,

This code presented error on my flowchart

error1