topic Number to date format in QlikView

Number to date format

manisha_uit — Tue, 13 Sep 2011 06:28:05 GMT

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

gandalfgray — Tue, 13 Sep 2011 07:08:30 GMT

Hi Manisha!

The query you presented is a SQL query.

As you noted you cannot use QlikView functions in a SQL query, you must use the syntax of the SQL dialect your using.

I suggest you search the web for Date functions for the database you are using.

Regards

/gg

rohit214 — Tue, 13 Sep 2011 07:14:46 GMT

hi manisha..

that query is in SQL.you can use function of SQL in qlikview but not qlikview function in SQL.

thanks

rohit