Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
SQL fiscal year logic help
David Smith
Sep 3 2012 11:43 AM
843
Reply
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;
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
RAID Configurations in SQL
dataGridView doesnt update SQL table