Need Date vs Create date & null fields

[Dausa67]

Good Afternoon,
I am working with "Create Date", "Need Date" populated and null.

How can I pull only records with a "Create Date" greater than the "Need Date" with out it including all "Need Date" fields that are empty?

Code # 1

IF ISNULL ({MASTER_SHORTAGE_VW.RESERVED_ON}) THEN "OTHER" ELSE
IF ({MASTER_SHORTAGE_VW.RESERVED_ON}) = ({MASTER_SHORTAGE_VW.TKS_NEEDED_BY}) THEN 1 ELSE
if ({MASTER_SHORTAGE_VW.RESERVED_ON}) > ({MASTER_SHORTAGE_VW.TKS_NEEDED_BY}) then 2 ELSE 0

The results are no records.
Any suggestions





Clay

 

[IanWaterman]

Where are you using this, it will not work in a select statement.

You you want to identify or filter the records

To filter try

not Isnull({MASTER_SHORTAGE_VW.TKS_NEEDED_BY}) and
({MASTER_SHORTAGE_VW.RESERVED_ON}) > ({MASTER_SHORTAGE_VW.TKS_NEEDED_BY})

Ian