How to do a count on field only if another field is not null

[#1]

I am trying to do a count of users who currently have a termed date in our system.  I have the following fields, [Full Name] and [Date Termed].  I just need the number of users where the [Date Termed] is not null.

[#2]

count([Date Termed])

[#3]

count([Date Termed])

[#4 · Accepted solution]

write this syntax in expression

if([Date Termed]<>'',count([Full Name]))

************************************************

or in script writ this

load

[Full Name]

count(if([Date Termed]<>'',[Full Name])) as countFullname

from table

group by [Full Name];

[#5]

now what if i wanted to do it for after a specific date, say 01-01-2014?  I can't get the syntax right for the where clause.

[#6]

try this

if(date([Date Termed],'DD-MM-YYYY')>'01-01-2014',COUNT([Full Name]))