time format(how to convert my reload time format from EST to IST ?)

[#1]

ineed to convert reload time of my QVW  from EST format  to  IST

my Present   Qvw  reload time - 01/07/2015 10:00 pm NewYork time

but my expected output should be like below for above time stamp :   02/07/2015 7:30 am  IST

and  whiile  tryiing below function i am getting this result  "2/7/2015 3:31:19 AM" instead of "02/07/2015 7:30 AM"

=ConvertToLocalTime(ReloadTime(), 'UTC+05:30')

please sugeest me  1.what is wrong in above syntax ..

                              2.why am getting  difference in time

[MK_QSL]

=ConvertToLocalTime(Now(),'New Delhi')

=ConvertToLocalTime(ReloadTime(),'New Delhi')

[#3]

Hi manish,

i tried with your logic(=ConvertToLocalTime(ReloadTime(),'New Delhi')) 

but still it showing "2/7/2015 3:31:19 AM"  instead of 2/7/2015 7:30:00 AM".

my problem is  time difference coming here , not showing exact time

as per time calculation  Newyork  time 10:00 pm is equal to our india time  7:30 Am  .

so am exepcting time " 7:30 am" here instead of "3:31 am"

please suggest  me ina bove case

[MK_QSL]

What is your Reloadtime()?

I hope you are not comparing ReloadTime() with Now() !

[Kushal_Chawda]

Try,

Create below two variable in the beginning of the script so that when application is being reloading, reload time will be captured as UTC time

let vUTC = timestamp(UTC(),'MM/DD/YYYY hh:mm:ss');

let vIST = timestamp(ConvertToLocalTime(Timestamp#('$(vUTC)','MM/DD/YYYY hh:mm:ss'),'Mumbai'),'MM/DD/YYYY hh:mm:ss TT');

Check the value of variable vIST

[Anonymous]

Hi,

Try this =ConvertToLocalTime(UTC(ReloadTime()), 'GMT+05:30')