Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

Time Stamp Issue

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Time Stamp Issue

3 Replies

Re: Time Stamp Issue

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

rittermd
Honored Contributor

Re: Time Stamp Issue

Tried this and it dropped the time completely.

It now just displays the date.

MVP
MVP

Re: Time Stamp Issue