topic Re: Log File Date format in QlikView

Log File Date format

jeevays7 — Fri, 15 Jun 2018 10:22:29 GMT

Hi All,

I'm trying to find out the duration of each qlikview file that I'm reloading from the log file.I have a log file which display 12 hour time format with AM/PM (Q11.20 version) and another log file which display the 24 hour time format (Q12.10 version) .

now I want to change the time format in log File generation?

This is Old log file format: ( Q11.20)

14/05/18 7:41:14 AM: Execution started.

14/05/18 7:41:14 AM: QlikView Version:11.20.12904.0

14/05/18 7:41:14 AM: CPU Target

This is new log file format: (Q12.10)

2018-06-15 09:48:23 Execution started.

2018-06-15 09:48:23 QlikView Desktop Version 12.10.20700+2018-02-09 15:37:07.HEAD.Component.Version

2018-06-15 09:48:23 CPU Target

I want the same format as the old log Files. How to do?

Please help me.

Re: Log File Date format

marcus_sommer — Fri, 15 Jun 2018 10:50:30 GMT

AFAIK it's not customizable/possible. This meant you need to handle different formattings within your load and this could be done with:

date(alt(date#(Timestamp, FormatOld), date#(Timestamp, FormatNew)))

- Marcus

Re: Log File Date format

Peter_Cammaert — Fri, 15 Jun 2018 10:52:36 GMT

I'm not sure that you can actually change the timestamp format for script logs. In earlier versions, timestamps on servers would follow the server regional settings for dates and times. The new format however is called 'Database Format' and doesn't change. Also, this format is fixed as a Year-Month-Day sequence, i.e. Months and Days will never be swapped.

And on top of that, all QlikView products understand 'database format' when they see it...

IMHO it shouldn't be that difficult to test for the presence of timestamps in 'database format' as it's about the only format that has a hyphen in position 5.

Re: Log File Date format

jeevays7 — Fri, 15 Jun 2018 11:14:50 GMT

Thank you Marcus.

Re: Log File Date format

jeevays7 — Fri, 15 Jun 2018 11:15:16 GMT

Thank you peter.