Variables

[#1]

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

[tamilarasu]

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.

[#3]

thank you tamil, it helped

[tamilarasu]

You are welcome, Dlamini.