topic SQL WHERE Date >Today() in QlikView

SQL WHERE Date >Today()

sculptorlv — Mon, 04 Jan 2016 13:00:13 GMT

Hello!

I have SQL table and column Date.

Is it possible to make WHERE limited selection in order to get only records with Data for last tree month..... like

InMonth(Date,Today(),-3)

MK_QSL — Mon, 04 Jan 2016 13:02:04 GMT

Create a Variable as below

Let vTodayMinus3Month = AddMonths(Today(),-3);

Now load as per

TableName:

Load * From TableName Where Date >= '$(vTodayMinus3Month)';

Chanty4u — Mon, 04 Jan 2016 13:03:05 GMT

create a variable for that 3mnths and use it in load stmnt..

jonathandienst — Mon, 04 Jan 2016 13:05:25 GMT

If you are doing the comparison on the SQL Where clause, you can use the SQL syntax supported by your server - for example, in SQL Server

SQL SELECT *

From dbo.MyData

Where Date >= DateAdd(m, -3, GetDate());

MySQL, Oracle etc will have different syntax - but this avoids date formatting issues.

koushik_btech20 — Mon, 04 Jan 2016 13:17:21 GMT

Hi Ruslans,

You can do these using variables,

LET vStartDate= Monthstart(Addmonths(Today(),-3))

so by these variable it will consider like for today it will take then it will return , 01/10/2015

after that you can use that variable inside SQL statement by,

Last3MDATA:

LAOD *;

SQL SELECT *

From dbo.MyData

Where Date >= $(vStartdate);

Note:Please check the date format in every area(DD/MM/YYYY or YYYY-MM-DD)

Regards,

Koushik

sculptorlv — Mon, 04 Jan 2016 13:24:07 GMT

Thanks, that is exactly what I wanted.