Time conversion at Query Level

[Former Member]

Can anyone suggest any methods to convert the time from UTC time zone to PST time zone at Query level without changing at backend level???

[former_member183777 · Accepted solution]

If it is a key figure you can create a formula and add the offset.

If it is a characterisitc and you want to limit the selection you can use customer exit variables. If you want to display the characteristic value, then you may be able to do a replacement path variable to convert characterisitc to KF and then use a formula to adjust the offset.