Cursor returns null

I have the method below.

When i run it, the column "D" returns null values but if i and run the printed sql string in sqllite manager, there are values though some rows are null.

Here is the method.

public List<ActiveTenancy> getUnInvoicedRooms(String mydate)
{
    List<ActiveTenancy> payments= new ArrayList<ActiveTenancy>();

        String sql ="SELECT Apartments.Number as N,Tenants.FirstName as F,Tenants.SurName as S ,"+
                   " (select Max(Rental_invoices.enddate)  from Rental_invoices inner Join Tenancy on Tenancy._id=Rental_invoices.tenancy_id "+
                  " where Tenancy.tenant_id=Tenants._id ) as D" +
                  " from Tenants "+               
                  " inner join Tenancy on Tenancy.tenant_id=Tenants._id "+
                 " inner join Apartments on Apartments._id=Tenancy.apartment_id "+
                " where Tenancy._id not  in(select  Rental_invoices.tenancy_id from Rental_invoices where enddate " + ">=?" + ")"+
                " and Tenancy.InActive=0";
 String[] args= new String[]{mydate};
        Log.e("sql", sql);
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor c = db.rawQuery(sql, args);
        if(c.moveToFirst()){
            do{
                ActiveTenancy a= new ActiveTenancy();
                a.setFirstName(c.getString(c.getColumnIndex("F")));
                a.setSurname(c.getString(c.getColumnIndex("S")));
                a.setApartment(c.getString(c.getColumnIndex("N")));

                if(c.getString(c.getColumnIndex("D"))!=null)
                {
                    Log.e("dddd",c.getString(c.getColumnIndex("D")));
                try {
                    a.setEnd_date(fm.parse(c.getString(c.getColumnIndex("D"))));
                } catch (ParseException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                }
                payments .add(a);
            } while(c.moveToNext());
            }
         c.close();
    return payments;

}

Anything causing this?

Ronald