Current Selection Box to show Date

[#1]

Good Morning.

I have build a report on Qlikview to show all the call logged on our helpdesk database.  I have a calendar object which shows my Start and End Date and I pull up the details in between and equaling those dates.  However as I have to set this as a number field so that I can get my Variable to work correctly, the current selections box now shows as a number instead of a date.

Is there anyway of changing this without getting my logdate field to date as it will stop me being able to search between the date criteria.

Regards,

Jon Ditchfield

[#2]

Hi jon

Yes  no worries

you date is under numeric format but you can show it as =date(DateFieldName, 'DD/MM/YY')  for example or others formats you can find in Help tab

best regards

Chris

[nilesh_gangurde]

Hi,

you can change the date to number using num() function.

and number to date using Date() function.

and these functions you can use at script level as well as at frontend.

so take date AS NUMBER from script and convert the same into date at frontend

-Nilesh

[brijesh1991]

there must be some variable in your start date and end date calender object, right?

goto those both calender object's number tab and set it Date format

See the attachment

Let me know if you need exact example