Where Clause With Excel Load Not Working As Expected

[pnn44794]

Hello:

I'm attempting to load an Excel file where I have dates from 2016 and 2017 in the format of "M/D/YYYY  hh:mm:ss AM" (or PM) or formatted "MM/DD/YYYY  hh:mm:ss AM" (or PM), depending on the month and / or day.  There's a total of 400 records.  When I use the following snippet of code, it reduces the number of rows fetched to 289.

LOAD a,

b,

Date(Created, 'MM/DD/YYYY') as Created,

.

.

.

last-field;

FROM
xyz.xlsx
(ooxml, embedded labels, table is [Spend-Data])
Where [Created] > '12/31/2016'; 

Does any one have any ideas on why this isn't working?  As always, thanks in advance and any and all help is appreciated.

[swuehl]

And double check your Created field can be interpreted as timestamp or date:

Why don’t my dates work?

Get the Dates Right

[pnn44794]

Hello Sas:

Hope this helps.

[pnn44794]

Hello Anil:

Hope this helps.

[pnn44794]

Come on Stefan!!!!  That would be too easy.  LOL.  I definitely was making it harder to do than it needed to be.  A rookie problem I suppose.    Your Where clause worked.  Thank you very much.  I appreciate the help.

[pnn44794]

And thank you for the links.  I have bookmarked them.  Thanks again for the help.