How to convert the UTC to the normal DateTime format?

[eimon]

Hello
I put the DatePicker on the apps that created by the uipath apps. Then that date will be stored in the uipath DataService when click the register button.

The date will be stored in Argument in_OrderDate as String and then assign to the dataservice.
obj_OrderReceived1.OrderDate=Convert.ToDateTime(in_OrderDate)

It works.

But when i change to the DatePick , It returns the UTC .How can i change UTC to the DateTime Format?

I read this link and still dont understand . Solution on how to convert DateTime variables between UTC and Local or a specific timezone

Thanks you in advace.

[Srini84 (Srinivas Kadamati)]

@eimon

Check below for your reference

Reference

Timestamp format when it contains time zone

Hello experts I am new to uipath and trying to read mail timestamp from Gmail using imap activities . I am trying to parse date/timestamp using Datetime.ParseExact and convert to string. I would like to know what will be format string for this function when date/ timestamp are given in format below Mon, 23 Nov 2020 15:31:54 +0000 Mon, 23 Nov 2020 02:18:45 -0600 (CST) Sun, 22 Nov 2020 23:59:53 -0800 As of now I am using format like this “ddd, d MMM yyyy HH:mm:ss -0600 (CST)” Bu it will …

Hope this may help you

Thanks

[ppr (Peter Preuss)]

@eimon
what is your local timezone? Is it to expect that the solution will be executed within different timezone on different locations?

[eimon]

Hello @ppr
my local time zone is GMT+9.
no, it is not to expect .
Thanks

[ppr (Peter Preuss)]

@eimon

my local time zone is GMT+9.

was asking for the timezone name

[Kalees9486 (Ashwin Kaleeswaran)]

Hi @eimon,

Try to use the Conversion syntax to change the whichever date format into the required format.
I have implemented the logic & hope this is what your looking for.

User this syntax: Convert.ToDateTime(inputDate).toString(“MM/dd/yy hh:mm:ss”)

If facing any other issues, reply back.

Thanks,
Ashwin

[eimon]

oh sorry.misunderstanding
(UTC+09:00) Osaka, Sapporo, Tokyo

Tokyo Standard Time

TST

[ppr (Peter Preuss)]

TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow,TimeZoneInfo.FindSystemTimeZoneById("Tokyo Standard Time"))

not serious meant, for entertainings:

[eimon]

Hello @ppr

I assign here .
obj_OrderReceived1.OrderDate=TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow,TimeZoneInfo.FindSystemTimeZoneById(“Tokyo Standard Time”))

It shows error.

Where do i suppose to set bind data “in_orderdate” arguments ?
Thanks

[eimon]

Hello @Kalees9486 It didnt go well .

Thanks eimon

[eimon]

DataServiceJuchutoroku.zip (12.4 KB)

arguments comes from the apps and assign to the entity of the dataservice.
my question was wrong.
how to assign utc type to the entity of datetime format.