DATE

[ankit777]

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]

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]

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]

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

[PrashantSangle]

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,

PS

[jschrader]

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]

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]

In between these days u will get the date

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