Time stamp dynamic change

[rathnam_qv]

Hi All,

in my report i have create a times tamp which shows the india time...

my requirement is if some one from US is opened the same report the time should change dynamically to US time.

how to achieve it?

Thanks,

Muni.

[MK_QSL]

Never worked with below function but you can try it...

localtime()

[datanibbler]

Hi rathnam,

look at the functions you have to query information from the machine QlikView is used on, e.g. OSUSER() - that will return the domain., Maybe you can use that to identify the location?

HTH

[#4]

Hello Muni - Did you try using CONVERTTOLOCALTIME() function? I have used this function in this way to achieve such goal: CONVERTTOLOCALTIME([Date Field],TIMEZONE())

Qlikview reference manual has further examples like:

ConvertToLocalTime(’2007-11-10 23:59:00’,’Paris’) returns ’2007-11-11 00:59:00’ and the corresponding internal timestamp representation. [Source: Qlikview Reference Manual]

ConvertToLocalTime(UTC(), ‘GMT-05:00’) returns the time for the North American east coast, e.g. New York.[Source: Qlikview Reference Manual]

[abhaysingh]

Hi raish..

i have one concern..suppose your application is placed somewhere in india and you you used converttolocal function it will give you time of server setted in Server obviously as per indian time. and suppose u r opening this application in US will it give you US time ??? i dont think it will..

thanks