filer data based on date filter

[anuradhaa]

Hi,

See attached.

Here i want to import data which has "Accepted at" in 2011.

[sunny_talwar · Accepted solution]

Just responded to your previous post also. May be this:

SET DateFormat='D-MMM-YY';

Table:

LOAD Id,

    [Created at],

    [Accepted at]

FROM

testcsv.xlsx

(ooxml, embedded labels, table is Sheet1)

Where [Accepted at] > MakeDate(2011, 1, 1);

[#3]

Also this might work,

it's similar to the above example but you dont have to change the date format (if for some reason thats necesary)

LOAD Id,

     [Created at],

     [Accepted at]

FROM

testcsv.csv

(txt, codepage is 1255, embedded labels, delimiter is ',', msq)

Where Year(date#([Created at], 'DD-MMM-YY')) = 2011;