Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
am still new to qlikview, so I would like to know how to I insert SQL variables in qlikview...please see SQL variables I want to insert
declare @Yesterday varchar (8)
declare @today varchar (8)
declare @FirstDayOfCurrMonth varchar (8)
declare @LastDayOfCurrMonth varchar (8)
set @Yesterday = (select convert(varchar,DATEADD(d, -1, getdate()),112 ))
set @today = (select convert(varchar,getdate(),112 ))
set @FirstDayOfCurrMonth = (select convert(varchar,dateadd(d,-(day(dateadd(m,-0,getdate()-1))),dateadd(m,-0,getdate()-0)),112))
set @LastDayOfCurrMonth = (select CONVERT(varchar,dateadd(d,-(day(dateadd(m,1,getdate()))),dateadd(m,1,getdate())),112))
print @Yesterday
print @today
print @FirstDayOfCurrMonth
print @LastDayOfCurrMonth
thanks
Hi,
You can try like below
Let vToday = Today();
Let vYesterday = Date(Today()-1);
Let vMonthStart = Monthstart(Today());
Let vMonthEnd = MonthEnd(Today());
If you want specific date format, you can change the environment variable like SET DateFormat='DD/MM/YYYY'; or whatever required.
thank you tamil, it helped
You are welcome, Dlamini.