Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=ConvertToLocalTime(Now(),'New Delhi')
=ConvertToLocalTime(ReloadTime(),'New Delhi')
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
What is your Reloadtime()?
I hope you are not comparing ReloadTime() with Now() !
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
Hi,
Try this =ConvertToLocalTime(UTC(ReloadTime()), 'GMT+05:30')