Numeric value is shown when selecting date-value

[#1]

Dear all,

I have the following Qlikview file in which I created a date-object in which I can select a data. If I create a text object in which show the the selected variable as object using =date(vDateInput) it shows the selected date.

But when I select a data I the date-object I do not see date but I see a numeric value. Any thoughts on how I can make sure I see a normal date here?

[Anonymous]

Hi

Seems to be CALENDAR OBJECT

go to  tabe Number ...>Override Document setting(check)....>Date(check)....>Format pattern(MM-DD-YYYY)

[#3]

Sorry Allu, its not clear to me. Could you please elaborate?

[Frank_Hartmann]

hi, see attached sample

hope this helps

[qlik_venu]

adding to the above answers,

You can also format your date range using

VFromDate: DATE#(20110101,'yyyymmdd')

and in the range definition of the calendar object you can use $(VFromDate).

[Anonymous]

Hi

PFA

[rajuamet]

Hi Marc,

PFA