topic Re. :Re: cast varchar to date in QlikView

cast varchar to date

Wed, 05 May 2010 09:30:46 GMT

Hi! All

I'm new to Qlikview..

I have a input box which takes a date.. so i'm trying to pass that value to a stored procedure

SET vID=cast('$(vID)' as int);
SET vStartDate=cast ('$(vStartDate)' as datetime);
SET vEndDate=cast('$(vEndDate)' as datetime);

SQL EXEC rpt_Machine_Details '$(vID)','$(vStartDate)', '$(vEndDate)'

I get an error that says Cast is not a valid function .

Is there a way to get a calender object just like in SSRS?

cast varchar to date

spsrk_84 — Wed, 05 May 2010 10:24:35 GMT

Hi,

Did you tried to pass the parameters directly,check that if that works then use the variables and pass the parameters..

Regards,

Ajay

Re. :cast varchar to date

martin59 — Wed, 05 May 2010 10:25:28 GMT

Hello,

What do you want to do ?

You have 2 dates (Begin + End) and you want to generate a Calendar table ?

You can only use your SQL functions into the QlikView's SQL instruction (SQL SELECT, SQL SET...)

Is it help you ?

Martin

cast varchar to date

Wed, 05 May 2010 10:36:03 GMT

Hi Thanks for the reply..

When I pass the parameters directly it works perfect.. The problem come when I enter the date on the input box because it interpretes the data as varchar "2009-01-01"

So i'm trying to Cast that to date.

Is there a way I can choose the dates from a calendar instead of typing it in ?

@Martin

I don't want to generate a calendar table i just want to be able to select a date from a calendar and what ever date i select has to be assigned to (Begin or End date) variables from there i want to pass those variables to a stored procedure as parameters.

thanks.

Re. :Re: cast varchar to date

martin59 — Wed, 05 May 2010 10:52:29 GMT

You can use the calendar object to select a date which in a field, and obtain this value with the function "Only(FieldDate)".

Otherwise, you can use the input box and transform your varchar into a date format with the function "date#('2009-01-01','YYYY-MM-DD')"

Is it what you want ?

Re. :Re: cast varchar to date

Wed, 05 May 2010 11:20:48 GMT

@Martin

Thanks its working perfect.

Is there any calendar object besides the calendar Slider which i can use to select the dates..?

Re. :Re: Re. :Re: cast varchar to date

martin59 — Wed, 05 May 2010 11:38:34 GMT

You can use the calendar object, with "Calendar" as input style.

You also can divide you date into 3 fields (Year, Month, Day) and show the list box.

Martin

Re. :Re: Re. :Re: cast varchar to date

Wed, 05 May 2010 12:10:34 GMT

Thanks a lot Martin that's what I wanted to do using the calendar object

Thanks a million

Re. :Re: Re. :Re: cast varchar to date

Wed, 05 May 2010 12:31:59 GMT

Marthin, how come I can only see 1900 as the year and Jan or Dec on month when i'm using Calendar as input style

Re. :Re: Re. :Re: Re. :Re: cast varchar to date

martin59 — Wed, 05 May 2010 12:43:10 GMT

Certainly because your date is not in the right format. You can use the date#() function in your load script.