Date Field

[#1]

Hi,

I have used the list box to display only the Year of the Dates using the Code Year(Atime).

And the list box has the values as 2008,2009 accordingly. But In the Current selections box it is howing some Junk value as 7078 of 137351. It is the same case for the Month as well. Why Junk values are shown in the Current Selections Box.

Date is stored in milliseconds in database and i have converted in to Actual Date format using the To_Char by adding 1970. And it is working fine. Is it the reason the Current Selections showing Junk Values?

Regards,

VSJ

[#2]

Thanks sicilianif . It is very clear your explanation.

My query is while creating the calender table you have used the Year and Date function. I am using the same functions in the Object.

If it is created as calender table it is showing the year and Date in the Current selection box.

If it is created at object level it is showing the distinct count.

Is it the Bug in Qlikview or the Functionality of the Qlikview. Can u please explain me to understand that.....

Thanks in Advance for the same.