Extract Data where year > 2003 or Null 1

[Hillary]

I want to pull students who have not graduated yet. In the gratuation field there is either 2003, 2002, 0 or Null. I want students who have the graduation date field Null or 0

I tried > 2002 but the system only returns 0.

What formula would I use to include both Null and 0?

Thanks,

Hillary

 

[kskid]

Assuming that Graduation date is a date field, then try this.

IsNull({GraduationDate}) or year({GraduationDate}) > 2003

-LW

 

[kskid]

Forgot the 0

(
IsNull({GraduationDate}) or
{GraduationDate} = 0 or
year({GraduationDate}) > 2003
)

In short, you have to check for nulls first.

-LW

 

[Hillary]

I never knew to check for Nulls first.

Thanks!

Hillary