Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manisha_uit
Contributor

Number to date format

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

2 Replies
gandalfgray
Valued Contributor

Number to date format

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
Contributor III

Number to date format

hi manisha..

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

thanks

rohit

Community Browser