Ms Outlook VBO incorrect timestamps

[harshilmehta]

Hi, 

Blue Prism Ms Outlook VBO retrieves email with incorrect timestamp. Somehow it gets email with UTC timezone. How can I receive email with local time zone without any conversion? Is there any setting on App Server or DB end to fix this issue? 



Regards,
Harshil

[ewilson]

See my response to your other post.

https://community.blueprism.com/communities/community-home/digestviewer/view-question?ContributedContentKey=65e42541-eebd-49aa-a6a8-03a73c44fdca&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=d...

Cheers,
Eric

[devneetmohanty07]

Hi Harshil,

Since you are getting the timestamp in UTC timezone. You can simply retrieve the item and add the time difference to this in order to convert it into your Local Time zone. For example: if your time zone is IST, add 5 hours and 30 min to your UTC retrieved time zone and it will give you the desired result. Use a calculation stage and use: [UTC DateTime] + MakeTimeSpan(0,5,30,0) where [UTC DateTime] corresponds to the timestamp retrieved for converting to local time,

Another way to convert it is to use the Date and Time Manipulation VBO from Blue Prism where you can use the "Get Timezones" action to get a collection all available timezones and also get the respective time zone ID and then use that time zone ID as an input in another action for the same VBO which converts the UTC time to any local time based on the time zone ID supplied. You can find the asset here: Date and Time Manipulation VBO

However, I suggest to use the first approach as it is a lot easier to implement and as your own way you can configure it. Let us know if that helps to resolve your query.