C# Convert int fiscalYear to datetime or datetimepicker

sammi taylor

This is what I started. I have a CaseOpened date that restricts dates to fiscalYear date but no future dates allowed.

int fiscalYear;

if (MyCase.CaseOpened.Month >=7)

fiscalYear = MyCase.CaseOpened.Year +1;

//Use fiscalYear in datetimepickers for min/maxdate. My fiscal year runs from july of previous year to july of this year. Today's date is the maxDate, past dates from July of last year to today's date can be entered for minDate. I don't know how to manipulate date with If Else.

datetimepicker1 maxDate = datetime.today;

datetimepicker1 minDate = fiscalYear date + maxDate;

if (MyCase.CaseOpened == null)

{

myCase.CaseOpened=minDate;

MyCase.CaseOpened=maxDate;

}

else

error msg, "Future dates are not allowed."

Please help. I could be doing it all wrong. Thank you in advance.

else
fiscalYear = MyCase.CaseOpened.Year;

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
I didn't entirely follow that but you can get the start and end dates of the current fiscal year as follows:

int year = DateTime.Today.Year;
int month = DateTime.Today.Month;
DateTime fiscalYearStart;

if(month < 7)
{
fiscalYearStart = new DateTime (year, 1, 1).AddMonths(-6);
}
else
{
fiscalYearStart = new DateTime (year, 1, 1).AddMonths(6);
}

DateTime fiscalYearEnd = fiscalYearStart.AddYears(1).AddDays(-1);
+1
sammi taylor12y ago
Wow. Thank you so much. Your dateTime format for my fiscalYear worked. I was able to create & finish my If else statement with validation results succesfully. Thank you so much for the help. I bow to your wisdom!! It turns out I did not need all the datetimepicker stuff.
0