Convert Date from CET / IST to UTC

[sunilvs24]

Hello,

I have a request where the user selected date to be converted to UTC date & time. The date is coming from an add-in, users in India would use IST & from Europe it would be CET.

Is there any generic function through which i can convert the date & Time to UTC Time.

I will be able to get the region to determine IST or CET. I did check couple of links on google, but did not find any satisfactory solution.

Thanks !!

Regards,

[6StringJazzer]

There is not a function but the formula is very simple and you can write your own named formula to do this.

IST is UTC+5:30. The formula to convert a date/time from IST to UTC is

Please Login or Register  to view this content.

CET is UTC+1:00 so to convert from CET to UTC:

Please Login or Register  to view this content.

(This will work for date/time but not just time values because it does not take into account crossing day boundaries.)

[sunilvs24]

Thanks Jeff, it helps