Getting expiredate from table if equal or less then today SQL server CE

See more:

C#

SQL

WinForms

Some help would be appreciated.
I have a table tblItem with columns ExpireDate (DateTime), AlertDays (Int).
Each Item I insert has an expiredate, I want to be alert in x days before the expiredate.
I want to count all the items where today + alertdays <= ExpireDate.
I have the following code but it is causing an error:

There was an error parsing the query. [ Token line number = 1,Token line offset = 48,Token in error = select ]

internal static int getAlertDateExpire()
{
    SqlCeConnection con = ConectionAndData.Con;

    if (con.State == System.Data.ConnectionState.Closed)
        con.Open();

    int number = 0;

    string sqlCommand = "select count(*) from tblItem where (Getdate()+(select AlertDays from tblItem)) As today <= ExpireDate";

    SqlCeCommand com = new SqlCeCommand(sqlCommand, con);

    try
    {
        number = (Int32)com.ExecuteScalar();
    }
    catch (Exception ex)
    {
        throw ex;
    }
    finally
    {
        con.Close();
    }

    return number;
}

What I have tried:

string sqlCommand = "(select count(*) from tblItem where DATEADD(day, (select AlertDays from tblItem) ,Getdate()) <= ExpireDate)";