date restrictions in query.

[Former Member]

Hi All,

I have a characterisitc Expiration Date on which I have to use some restrictions in a query. The logic should be this:

If expdt = "" or expdt = NULL or expdt > currentdt.

How can I accomplish this?

Thanks!

[Former Member]

Hi Uday,

Genrally this kind of transformation is better in AWB.

If necessary in query I suggest you to convert all Dates in Formula Variables, so to apply Formulas (in Formula under indicator section in columns or rows) on the same.

Ciao.

Riccardo.