How to select records without a value AND greater than a certain value

[Dayna]

Hello!

I'm trying to set up some functionality on one of my date fields, where a user would like to select:

Anything without a value (obviously I can set something in the load statement for when null value = no value set flag) AND anything greater than a certain date.

i.e. All values without a expiry date AND greater than the 20/02/2014.

Thanks for your help!

Kind Regards,

Dayna

[alexandros17]

It's only an idea but if you have not expire date set the field value to 2099/12/31 so when you look for date >= than a certain value you'll find even the one with no date ...

Hoipe it helps

[Dayna]

That'll do the job, thanks Alessandro!