Filtering data in load script

[ashis]

Hi,

In my load script i have a date field xxx as

date(xxx, 'DD/MM/YYYY hh:mm:ss tt') as xxx,

based on this field i want to filter my data . So in the where clause i put

where DATE(xxx,'DD/MM/YYYY hh:mm:ss tt')>'12/11/2017 00:00:00 AM' ;

My problem is I only get data after 12/11/2017 for year 2017 but 2018 data is not coming.

Thank you,

Ashis

[sunny_talwar]

Is this where clause used in SQL SELECT statement or LOAD statement? Also, are you sure you have data for 2018 in your source data?

[ashis]

This is used in Load statement , reading data from QVD. Yes I do have data for 2018.

If I remove where clause I do get data for Jan- 2018.

[sunny_talwar · Accepted solution]

Can you try this

Where xxx > MakeDate(2017, 12, 11);

[ashis]

Great, it works... Thank you Sunny.

[ashis]

Any guess why my piece of code breaking.

[sunny_talwar]

Difficult to say, but my guess is that it is unable to read he string as a date... it is doing something else which is why there are issues....