Time Stamp Issue

[rittermd]

I am displaying the TimeStamp that is on the following log file:

Engine\Audit\WIN-IVTIROI5TAF_AuditActivity_Engine.txt

I just opened an app at 10:28 AM EST.

When I reloaded the app and view the date time stamp it is showing the time as 14:01

I checked the QS server and the time and time zone are correct. 

Is there some place else that I need to set the correct Time Zone?

We are running 3.0 of QS the server version.

I am converting the time stamp in the script as follows:

Date(Timestamp("Timestamp"),'MM/DD/YYYY hh:mm') as date,

Is it possible this expression is not returning the correct time?  The date is correct.

[MK_QSL]

Date(Floor(Timestamp#("Timestamp",'MM/DD/YYYY hh:mm'))) as date,

[rittermd]

Tried this and it dropped the time completely.

It now just displays the date.

[sunny_talwar · Accepted solution]

May be ConvertToLocalTime()

is the answer here:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/c...