particular month and year data

[vinod2086]

Hi frnds,

in my req i have a table that table contains more data but i need to display only feb 2015 to nov 2015. in script how to write condition

Thanks in advance

[sunny_talwar]

May be like this

Table:

LOAD     ....

FROM ....

Where DateField >= MakeDate(2015, 2) and DateField <= MakeDate(2015, 11);

[avinashelite]

add a where condition like

LOAD * from table

WHERE Month_Year>='Feb 2015' and Month_Year<='Nov 2015';

NOTE: All the date format should be in the same format