Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks Gysbert..:)