topic Re: help with dates in SQL in QlikView

help with dates in SQL

josephinetedesc — Tue, 08 Aug 2017 00:03:32 GMT

Hi All

I have looked at the discussion above but I need help to do the following:

Below is the current script to get the dates I am interested in - however what I want is not to hard code the ScheduledDate. I would like to change ScheduledDate < '2017-09-01'

and make it ScheduledDate < today() + 30

Is this possible given that 'today() + 30' is is qlikview but it is part of an SQL select?

Thank you

aaa:

SQL SELECT *

FROM Cccc.dbo.[vwdr_ppDays]

where ScheduledDate >= '2016-01-01' and ScheduledDate < '2017-09-01'

;

STORE

aaa INTO

[aaa.qvd] (qvd);

drop table aaa;

Re: help with dates in SQL

sunny_talwar — Tue, 08 Aug 2017 00:47:55 GMT

May be this

aaa:

SQL SELECT *

FROM Cccc.dbo.[vwdr_ppDays]

where ScheduledDate >= '2016-01-01' and ScheduledDate < (SYSDATE + 30);

Re: help with dates in SQL

sasiparupudi1 — Tue, 08 Aug 2017 01:13:28 GMT

Let vDate ='Date (Floor (Today ())+30),''YYYY-MM-DD'')'

In the sql where condition,

ScheduledDate<'$(vDate)'

hth

Sasi

Re: help with dates in SQL

josephinetedesc — Tue, 08 Aug 2017 02:46:35 GMT

Let vDate ='Date(Floor(Today())+30),''YYYY-MM-DD'')';

on using debug this s gives vDate as :"Date(Floor(Today())+30),'YYYY-MM-DD')"

and causes a problem when trying to use it.

Let vDate =Date(Floor(Today())+30); this gives the vDate as 7/09/2017 but then the problem is that it is in the wrong format.

Re: help with dates in SQL

sasiparupudi1 — Tue, 08 Aug 2017 03:59:05 GMT

Try

Let vDate =Date(Floor(Today())+30,'YYYY-MM-DD');

Re: help with dates in SQL

josephinetedesc — Tue, 08 Aug 2017 04:45:47 GMT

Thank you that worked! Where could I have found information about how to worked with dates as text???