I have an issue where I can't override date. The reason why I am trying to override is the fact I am trying to match academic year with fiscal year date. Fiscal year starts from July 1st - June 30. Especially, summer is a problematic because summer students enroll beyond July 1st that will be counted as Fall students of following Academic year. Therefore, I have a number of students are off between FY and AY. Here is MAX date I have for each academic year (SUMMER only) as they go beyond July 1st:
Table Name: Union of several academic year database
Thus, I created a calculated field as below to match summer with current academic year which otherwise will be counted as Fall students of next academic year:
Now, I used MAX to check if I have achieved my result or not:
First of all, it is very strange why I am not getting max date of 6/30/xxxx (again SUMMER only) after i have applied calculated field. Any idea why? Thank you
After all possible modifications, I found that i forgot to put single quotas within DATE functions. After I adjusted formula and also changed 7/30/xxxx to max date from each academic year, I was able to achieve my desired result.