SQL Stored Procedure into QlikView

[priyav24]

Hello Everybody,

I have used stored procedure for my qlikview dashboard,

By

Checking --Open database in read and write mode in the settings tab of the Editscript

and Used

Query

SQL

EXECUTE

[AUJANX3].[usp_sage_OutReg]  '1 dec 2012','31 dec 2012','0','ZZZZ' ,'0','ZZZZ','0','ZZZZ'

In this stored procedure ,

I have a field ACCDAT_0 is the datefield in a string format

I want that to modify as Date(ACCDAT_0 ) as Date

Is it possible in Qlikview??

Thanks in Advance!!!

Priya

[Gysbert_Wassenaar · Accepted solution]

You can use a preceding load to create the Date field:

LOAD *, date#(ACCDAT_0, 'D MMM YYYY') as Date;

SQL

EXECUTE

[AUJANX3].[usp_sage_OutReg]  '1 dec 2012','31 dec 2012','0','ZZZZ' ,'0','ZZZZ','0','ZZZZ';

Make sure you use specify the right date format. 'D MMM YYYY' is an example based on the date strings you passed to the stored procedure. If the stored procedure returns strings in a different format then you'll have to change the format in the date# function to that format.

[priyav24]

Thanks Gysbert..:)