topic Load date Format in V9 in QlikView

Load date Format in V9

lucarizziero — Sat, 19 Dec 2009 01:18:46 GMT

Hi all,

In the Local Client V 9.00.7320.7 SR2 the last load date has the british date format: is it possible to set it as the control panel date format ?

thanks

Load date Format in V9

MichaelRobertshaw — Sat, 19 Dec 2009 04:06:39 GMT

When displayed, Dates will be formatted according to the ControlPanel settings.

These can be overridden by defining SET DateFormat='D/MM/YYYY';

This can be overridden in the Document Properties where you define a Format specification for each Field or variable.

This can be overridden in the properties of the specific Object on the page that is displaying your data.

And you can always specify eg =Date(ReloadTime(),'MM/DD/YYYY')

SV:Re: Load date Format in V9

Tue, 29 Dec 2009 16:46:56 GMT

Hi!

Well. I don´t think it helps regarding to the logfile.

Even the logfile presents british date format.

I think It´s bug.

/Lasse

SV:Re: Load date Format in V9

prieper — Tue, 29 Dec 2009 20:39:37 GMT

In an office-environment using different language-settings it is more of advantage to have text-files (logfiles) in just one dateformat.

Peter

SV:Re: SV:Re: Load date Format in V9

Wed, 30 Dec 2009 19:06:14 GMT

Well, it wasn´t exactly what I meant. The format of ReloadTime() is "M/D/Y hh.mm.ss.ffff" as well as the format in the beginning of every row in a logfile.

As far as I remember was the format depending on the regional settings. I don´t know, but is there a way in the settings there I can change it?

Of course, our intention is to have a just one dateformat.

Lasse