Brent Frandsen on 12 Dec 2015 01:24:48
Currently, if converting a date/time to date/time/timezone datatype, the system applies the local timezone. Generally if I'm finding the need to add a timezone, it is because the data is NOT in my local timezone! Please allow user to choose which timezone to apply in this case. Detailed explanation and workaround provided by Ken Puls here: http://www.excelguru.ca/blog/2015/05/20/data-from-different-timezones/
- Comments (1)
RE: Allow user to select time zone when converting type to date/time/timezone
Hello Microsoft - This is a very important function. Currently we change it manually but it can lead to a lot of errors, please consider to add this functionality.