topic Replace in QlikView

Replace

Wed, 09 Nov 2011 10:58:44 GMT

I'm taking data for the last 45 days with a select function. I need to keep the data of the days before. For the first day i use the normal select. When i tried to use replace select it doesn't work. It only takes data for the day 45 (from today). What can cause this problem?

Replace

Wed, 09 Nov 2011 13:05:24 GMT

SQL:

SELECT [date]

FROM Table

WHERE [date] >= DATEADD(day, -45, CURRENT_TIMESTAMP);

Fetch all Values where date >= today - 45 days

http://msdn.microsoft.com/de-de/library/ms186819.aspx

Replace

Wed, 09 Nov 2011 14:24:18 GMT

I have a function like:

select * from function(day,other things)

I call it 45 times, choosing day as current date, current date -1,..., current date -45. The data for 46 days ago i still need it, but it is not changing anymore. The replace select is not working.

Re: Replace

Anonymous — Wed, 09 Nov 2011 18:11:33 GMT

replace function is used only for string or character conversion..use convert for date conversion

like convert (char(12),getdate(),103)

just change the third parameter to change the date style..