How to exclude unwanted year in Date field.

[MuraliPrasath]

Hi,

I just want to omit this year 1900 in my Date field.

[sunny_talwar]

Do it in the scrip while you are loading them

LOAD Date,

          otherFields

FROM xyz

Where Year(Date) <> 1900;

[amit_saini · Accepted solution]

Try:

where not Match(Year, '1900');

Thanks,

AS

[sunny_talwar]

Hahahaha your solution showed me my mistake, I was doing = 1900 instead of <> 1900

[amit_saini]

haha no worries

[MayilVahanan]

Hi

Try like this

Load * from datasource where Year(Date) <> 1900;