topic Re: Current Date in QlikView

Current Date

Thu, 12 Sep 2013 12:55:51 GMT

I would like to load a script. It connects to a DB and there i would like to load the data.

Is it possible to get the day yesterday and put it into where?

Andrea_Ghirardello — Thu, 12 Sep 2013 13:02:10 GMT

you can put the date into a variable:

Let yourVariable = Date(Today() -1);

MayilVahanan — Thu, 12 Sep 2013 13:03:34 GMT

Yes it's possible

Try like this

Load * where datefield <= Date(today()-1);

Select * from tablename;

Note:

both datefields are in same format

swuehl — Thu, 12 Sep 2013 13:05:06 GMT

Maybe like this:

Let vYesterday = date(today()-1,'YYYY-MM-DD'); // should match the format of your DB

SELECT DATE FROM DB WHERE DATE = '$(vYesterday)';

Thu, 12 Sep 2013 13:06:32 GMT

Like this in your edit script:

Let vDateToday = date(Today()-1);

Otherwise you could go to settings - > Variable overview -> add new and type date(today()-1)

You could also use this in your where statement from SQL

Where cast(date as date) = cast(getdate()-1 as date)