Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 22nd 2012 is stored as 41,051.5 , what this number signifies. Please tell .
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
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
Thats my question why it started to count from 12/31/1899
It is default...
Just to maintain a standard, they have set it like that way..
u cannot manually change it..
There are several date systems followed by different tools. The most common one (used by excel as well) is the one called:
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.
To keep it in sync with Excel. So, the integer representation of dates in QV and Excel are the same.