topic Re: DATE in QlikView

DATE

ankit777 — Thu, 03 Apr 2014 14:29:27 GMT

I WANT TO LAOD DATA FROM A TABLE WHERE DATE IS GREATER THAN 16-SEP-2011 AND LESS THAN 24-OCT-2011.

WHAT SCRIPT SHOULD I WRITE?

its_anandrjs — Thu, 03 Apr 2014 14:33:02 GMT

New update please check now

Load your table like

Load

Fields

From Location

Where DATE > '16-SEP-2011' AND DATE < '24-OCT-2011';

Note:- But be specific about your Date format which is exactly match with DATE = '24-OCT-2011'

ankit777 — Thu, 03 Apr 2014 14:41:49 GMT

IN MY TABLE THE FORMAT IS LIKE '16-SEP-2011

i M USING THE SAME QUERRY

BUT M NOT GETTING THE DESIRED RESULT.'

its_anandrjs — Thu, 03 Apr 2014 14:43:18 GMT

Convert date field into num or then use it for checking if you have sample then provide.

PrashantSangle — Thu, 03 Apr 2014 14:48:56 GMT

Hi,

use this in your where clause,

date#(datefield,'DD-MMM-YYYY') > '16-SEP-2011' AND date#(datefield,'DD-MMM-YYYY') < '24-OCT-2011';

Regards,

jschrader — Thu, 03 Apr 2014 14:48:58 GMT

If you want to load fields between two dates in another field called a_timestamp then you could do the following by using the date function.

Load:

date(a_timestamp, 'DD-MMM-YYYY')

From Location

Where a_timestamp > '03-MAR-2014' and a_timestamp < '10-MAR-2014'

;

its_anandrjs — Thu, 03 Apr 2014 14:54:09 GMT

Create a field like NumDate or you can directly check with date field like Date(Num(Date),'DD/MM/YYYY') as NumDate,

Where Date(Num(Date),'DD-MMM-YYYY') >= '2/29/2012' AND Date(Num(Date),'DD-MMM-YYYY') <= '2/29/2013';

LOAD

Dealer,

Sales

FROM Location

Where Date(Num(Date),'DD-MMM-YYYY') >= '2/29/2012' AND Date(Num(Date),'DD-MMM-YYYY') <= '2/29/2013';

nizamsha — Thu, 03 Apr 2014 15:07:48 GMT

In between these days u will get the date

Where Date > '6/5/2012' and Date <'11/10/2012'