DateTime conversion issue

[supu123 (supriys)]

Hii everyone,

is the issue
I want convert the string to datetime variable

Regards,
Supriya

[lakshman (Ganta lakshman)]

@supu123

First try to print value from Excel and check the format once. And also show me your expression once.

[supu123 (supriys)]

Hii @Lakshaman

Regards,
Supriya

[AshwinS2 (Ashwin S)]

Hi @supu123

Use a strvar and again startdatetime.toString(“MM/dd/yyyy”)

Thanks
Ashwin.S

[supu123 (supriys)]

Hi everyone,

Same error is displayed.

Regards,
Supriya

[AshwinS2 (Ashwin S)]

Hi @

In the screenshot you have given start datetime in double quotes and use it as normal startdatetime

Thanks
Ashwin.S

[supu123 (supriys)]

Hii

StartTime is a string
StartDateTime is a DateTime variable

I need to convert startTime to StartDateTime

Regards,
Supriya

[lakshman (Ganta lakshman)]

@supu123

Try this:

DateTime.ParseExact(startTime,“dd/M/yyyy HH:mm:ss tt”,CultureInfo.InvariantCulture)

Where startTime is of type String and input is coming from Excel file. Create one DataTime variable and store above expression result into it using Assign Activity.

[AshwinS2 (Ashwin S)]

Hi @supu123

Use starttime=startdatetime.ToString(“MM/dd/yyyy”)

Thanks
Ashwin.S

[supu123 (supriys)]

@lakshman

DateTime.ParseExact(startTime,“dd/M/yyyy HH:mm:ss tt”,CultureInfo.InvariantCulture)

Cultureinfo not defined

Regards,
Supriya

[AshwinS2 (Ashwin S)]

Create a variable as culture info and declare the type as culture

[lakshman (Ganta lakshman)]

@supu123

Write like this and see.

System.Globalization.CultureInfo.InvariantCulture

[ImPratham45 (Prathamesh Patil)]

@supu123 I dont know this is the proper way or not but you can review it
Hope it will help you…
BlankProcess2.zip (17.0 KB)