Discussion Board for collaboration on QlikView Scripting.
I have an SQL store procedure that has a following input parameters:
I would really want to have it dinamic, but cannot set it up like
using the following settings:
because I cannot get $(StartDate) and $(EndDate) in the same (nvarchar) format.
Could you please help?
Thank you very much in advance!!!
I found the solution myself:
LET StartDate=chr(39) & text(Monthstart(today(),-1)) & chr(39);
LET EndDate=chr(39) & text(Monthstart(today())) & chr(39);