topic Time Conversion in QlikView

Time Conversion

Fri, 19 Apr 2013 22:45:36 GMT

the raw data I got for time is something like 41271.378252315, how can I convert it to the date time format like "01/01/2013 05:01:33 am"?

Re: Time Conversion

Fri, 19 Apr 2013 23:00:49 GMT

Hi,

You should use the date() function, ex.

Date(41271.378252315, 'DD/MM/YYYY hh:mm:ss TT')

Date(41271.378252315, '$(TimestampFormat)') TimestampFormat is a QV System variable, it's define the full date time format. (See the script)

Regards,

Ricardo

Re: Time Conversion

Fri, 19 Apr 2013 23:51:38 GMT

Hi,

Have you tried using the date function? For instance

=date(41271.378252315) returns 12/28/2012

See attached.

Hope that helps.

Matt

Re: Time Conversion

montgomery7aust — Sat, 20 Apr 2013 02:03:06 GMT

Hi Kelly,

You have a couple of options, but the easiest is to load the field into an object and go to the Number tab and select Timestamp. You can also do this in the script editor by prefacing the field with Timestamp(<your date field here>), as shown below, and this will then show the field as a date whenever it's used in an object (aka globally).

LOAD Timestamp(Date)

FROM

[\\vmware-host\Shared Folders\Desktop\date.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hope this helps!

-Austin

Re: Time Conversion

kaushiknsolanki — Sat, 20 Apr 2013 05:22:48 GMT

Hi,

Try this.

Timestamp( 41271.378252315)

Regards,

Kaushik Solanki