Hi all,
I have a query as below:
select
'Future' as Aging_Descr,
'STD' as Aging_Id
from ps_item a, ps_item_activity b,
(
select (Date $(vCalendar) - a.accounting_dt) days
from ps_item a
)
where a.item =b.item
and days < 0
UNION
select
'Current' as Aging_Descr,
'STD' as Aging_Id
from ps_item a, ps_item_activity b,
(
select (Date $(vCalendar) - a.accounting_dt) days
from ps_item a
)
where a.item = b.item
and (days <= 30 and days>=0)
.........
Now, I want that user should enter a date(vCalendar) and based on that date qlikview will show the o/p.
But as 'Date' is a qlikview function so it's not converting this number into date type.
So how can i use this variable and convert it into date type.
Thanks
Manisha
