Is there a simpler way to write this logic below in c sharp or an Sql query, i am using access database
case 14://Current Fiscal Year
string TempYear = string.Empty;
if (DateTime.Now.Month < 7)
{
TempYear = string.Format("{0}", ((DateTime.Now.Year) - 1));
}
else
{
TempYear = string.Format("{0}", DateTime.Now.Year);
}
string FiscalYearStart = "7/1/" + TempYear;
string FiscalYearEnd = "6/30/" + (TempYear + 1);
sqlDateFilter = "tblService.ServiceDateStart >= #" + FiscalYearStart + "# AND ServiceDateStart <= #" + FiscalYearEnd + "#";
break;