Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor II

Time Format


May 22nd 2012 is stored as 41,051.5 , what this number signifies. Please tell .

6 Replies
Honored Contributor II

Re: Time Format

it represents the date and time as a number

22/05/2012 12:00

Paste it into excel and format it and it will show you it's a Date and time dd/mm/yyyy hh:mm

Re: Time Format

Qlikview Internally maintains Date as number.

41,051.5 in this

1 day is represented as 1

1 hour is represented as 1/24

1 minute is represented as 1 / (24 * 60) and so on

Starting from 12/31/1899 it counts 41051 When it is May 22nd.

Hope it helps

Valued Contributor II

Re: Time Format

Thats my question why it started to count from  12/31/1899

Valued Contributor II

Re: Time Format

It is default...

Just to maintain a standard, they have set it like that way..

u cannot manually change it..


Re: Time Format

There are several date systems followed by different tools. The most common one (used by excel as well) is the one called:

The 1900 Date System

In the 1900 date system, the first day that is supported is January 1, 1900. When you enter a date, the date is converted into a serial number that represents the number of elapsed days since January 1, 1900. For example, if you enter July 5, 1998, Microsoft Excel converts the date to the serial number 35981.

Qlikview uses 1900 Date System. Hence the number you see.

Hope clarifies.

Esteemed Contributor III

Re: Time Format

To keep it in sync with Excel.  So, the integer representation of dates in QV and Excel are the same.

Community Browser