dtCmbMissing.Columns.Add("MonthOnly", typeof(string));
dtCmbMissing.Columns.Add("YearOnly", typeof(string));
for (int i = 0; i < dtCmbMissing.Rows.Count; i++)
{
//DateTime dtDate = (Convert.ToDateTime(dtCmbFinal.Rows[i]["Date"]));
string strA = Convert.ToString(dtCmbMissing.Rows[i]["Date"]);
string[] strDateTime = strA.Split('/');
dtCmbMissing.Rows[i]["MonthOnly"] = strDateTime[1];
dtCmbMissing.Rows[i]["YearOnly"] = strDateTime[2];
}
dtCmbMissing.Columns.Add("YearOnly", typeof(string));
for (int i = 0; i < dtCmbMissing.Rows.Count; i++)
{
//DateTime dtDate = (Convert.ToDateTime(dtCmbFinal.Rows[i]["Date"]));
string strA = Convert.ToString(dtCmbMissing.Rows[i]["Date"]);
string[] strDateTime = strA.Split('/');
dtCmbMissing.Rows[i]["MonthOnly"] = strDateTime[1];
dtCmbMissing.Rows[i]["YearOnly"] = strDateTime[2];
}