Create calendar using date format dd/mm/yyyy hh:mm:ss

Wed, 17 Apr 2013 06:21:50 GMT

Hi All,

I am trying to create a data calendar with a data format that was originally as stated in the subject. I was not interested in the time stamp, therefore from the QVD itself, I rid mysel of the time stamp by using the date function, however, when I create a get convert it to number using NUM function, I get numbers followed by 4 decimal points. As a result I cannot match it to the autogenerated calendar when I convert the number back to date. Hope someone can understand my predicament.

Thanks

Re: Create calendar using date format dd/mm/yyyy hh:mm:ss

Wed, 17 Apr 2013 23:10:36 GMT

Just got the answer from a colleague, thought I would share it; So the problem is the date and time stamp creates a number with decimals, consequently, this cannot be matched to the data island that is created. So, fix the problem by using the Floor function which removes the decimal points and can then match it to the date island

topic Re: Create calendar using date format dd/mm/yyyy hh:mm:ss in QlikView

Create calendar using date format dd/mm/yyyy hh:mm:ss

Re: Create calendar using date format dd/mm/yyyy hh:mm:ss