2024-05-07T07:29:50.412Z

[devasaiprasad_K]

Hi Team,

i have exported some data from one of the Data source and the time stamp is as follows : 2024-05-07T07:29:50.412Z, i have seen some solution in C# pages and tried implementing the same but no luck

var d = new Date('2015-03-04T00:00:00.000Z');
console.log(d.getUTCHours()); // Hours
console.log(d.getUTCMinutes());
console.log(d.getUTCSeconds());

how can we fix the same in UiPath

[Yoichi]

Hi,

The following may help you.

yourString="2024-05-07T07:29:50.412Z"
varDateTime = CDate(yourString)
varUTC = varDateTime.ToUniversalTime()

Then

varUTC.Hour
varUTC.Minute
varUTC.Second

Sample (VB)
Sequence.xaml (7.1 KB)

Regards,

[devasaiprasad_K]

i have some similar thought, the reason i posted is, is there any functions like getUTCHours getUTCMinutes and so on in UiPath date function… i am checking on this as well… any further guidance would be helpful… and also will such kind of functions help directly to convert to IST?

[ppr (Peter Preuss)]

Maybe you was refering to this:

DatePrototype.getUTCHours(Object) Method (Microsoft.JScript)

But is only available in Legacy:

[ppr (Peter Preuss)]

@devasaiprasad_K

and also will such kind of functions help directly to convert to IST?

Have a look here:

TimeZoneInfo Class (System)

[Yoichi]

@ppr

But is only available in Legacy:

And also need to add reference to JScript.dll because it’s not refereed as default in UiPath.

Regards,

[ppr (Peter Preuss)]

@Yoichi

need to add reference to JScript.dll

correct. With the tendency to Windows and moving away from Legacy

[InfoSet] - LegacyToWindows Migration # Information Index

About this [InfoSet] - LegacyToWindows Migration series The [InfoSet] series summarise a topic and offer information resources of different kinds. The topic of Legacy-to-Windows migration was chosen for the [InfoSet] series to provide initial help. This information index is the landing page that lists all the different information resources. Blogs Tools & Guides Blueprint Block Topic Registration / Inventorisation / Prototyping Jump Start Guide - A series of questions and a check…

we recommend to focus on options which will be within the recommended project compatiblities and which were also mentioned above

[devasaiprasad_K]

Microsoft.JScript.dll should be added in folder path of Main.xaml?