2 Replies Latest reply: Sep 13, 2011 3:14 AM by rohit gupta RSS

    Number to date format

    Manisha Choudhary

      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