Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RH205BIP2
Contributor
Contributor

Governance dasboard 2.1.4 datetime issue

Hi,

The governance dashboard is not showing historical differences (previous session per user, sessions last 30 days) It looks like all the datefields are empty. I think because the timestamp cannot be formated correctly. Hope somebody could help me with it. 

This is the timestamp in our log files --> 20221218T100105.000+0100

In the governance script I see the following script/variables:

SET TimestampFormat = 'YYYY-MM-DD hh:mm:ss'; // This should be changed only if the Publisher machine in your system uses a timestamp format not included in the three TimestampFormat variables.

SET TimestampFormat1 = 'MM/DD/YYYY hh:mm:ss TT'; // First "fall back" timestamp option in case Publisher server has different locale/timestamp than the default.

SET TimestampFormat2 = 'DD.MM.YYYY hh:mm:ss'; // Second fall back timestamp format

Do I need to modify these, if yes how??

Thanks in  advance!!

Labels (2)
0 Replies