topic Re: Creating a string variable for today's date in QlikView

Creating a string variable for today's date

Mon, 16 Jul 2012 17:45:35 GMT

I would like to query a postgres database to load a table. I need to make the query dinamic. For Example, a simple query would look like this:

SELECT *

FROM table1

WHERE date(reportdate) = '2012-07-16'

I want to feed the date '2012-07-16' in WHERE statement above using today() function in the qlikview. So I need to convert the result of the Today() function in a string which looks like '2012-07-16'. so that i can write above query as:

SELECT *

FROM table1

WHERE date(reportdate) = $(vdate)

in this query $(vdate) should produce '2012-07-16'. How can i do that?

Re: Creating a string variable for today's date

Jason_Michaelides — Mon, 16 Jul 2012 17:49:18 GMT

Above the load portion of the scrip put:

Let vDate = Chr(39) & Date(Today(),'YYYY-MM-DD');

Then use the SELECT statement exactly as you write above.

Hope this helps,

Jason

Re: Creating a string variable for today's date

Jason_Michaelides — Mon, 16 Jul 2012 17:50:19 GMT

PS - the 'amp;' is my iPhone playing silly buggers....

Re: Creating a string variable for today's date

Jason_Michaelides — Mon, 16 Jul 2012 17:51:30 GMT

PPS - I forgot the closing Chr(39)...

Let vDate = Chr(39) & Date(Today(),'YYYY-MM-DD') & Chr(39);

(been a long day..)

Re: Creating a string variable for today's date

Mon, 16 Jul 2012 19:07:27 GMT

This worked. Thank you. Have a good one.