how can I restrict the loading of data to be greated than a certain date in a field called posting date

[#1]

how can I restrict the loading of data to be greater than a certain date in a field called posting date.  I tried by specifying the where posting date > 31-12-2014 but it still loads in all the years in the table. 

[kiranmanoharrode]

Where condition is correct for filtering data based on Date field.

But I think date format of posting date is diffrent than date format of where condition..

Regards,

Kiran

[Anonymous]

check your date format , first try to select data using your query from DB and see the result. what ever query will work in database. use that query in qlikview . I am sure your problem is date format only.

[#4]

Yes, it is the date format.

Thanks.

[kiranmanoharrode · Accepted solution]

Dear Jenny,

If you got the answer. Close this thread with marking correct answer...

Regards,

Kiran

[Anonymous]

are you able to select correct data from database when running query in DB for SQLDBX or any db client ?

[#7]

Hi Jenny,

To avoid playing with date format you can filter your data by using the number equivalent of date (31-12-2014) i.e 42004..

Consider the following example:

use where NUM([Posting Date])>'42004'

That will do ..i think so

Hope it helps you

regards,

Ankur

[#8]

yes. thank you.

[#9]

ok that is a great suggestion.  thanks.