How to convert SGT time to IST time in qlikview application

[Anonymous]

Hi All,

Dashboard is displaying SGT time. I need to convert it to IST time. Kindly do the needful.

Coding used to capture the refresh time :

timestamp(timestamp#(ReloadTime(),'MM/DD/YYY hh:mm:ss TT'),'DD-MMM-YYYY hh:mm:ss TT')

[vardhancse]

Hi,

In your script you can create new field like some thing below:

Timestamp(ReloadTime()-2.5,'hh:mm:ss TT') as ISTTime