Now they want 12 month projections of current date so this is what I have:
NumberVar Month1Total;
if (Month({PJPROJ.end_date}) = Month (CurrentDate)) and (Year({PJPROJ.end_date}) = Year(CurrentDate))
Then Month1Total := {vr_RVI_ProfitByJob.eac_Revenue} else 0
It doesn't quite work properly as it is not matching the month properly but it is matchig the year. Can't quite figure out why it's not working. The other problem is what happens when the year changes and I am doing 12 months from October? How do I handle that?
NumberVar Month1Total;
if (Month({PJPROJ.end_date}) = Month (CurrentDate)) and (Year({PJPROJ.end_date}) = Year(CurrentDate))
Then Month1Total := {vr_RVI_ProfitByJob.eac_Revenue} else 0
It doesn't quite work properly as it is not matching the month properly but it is matchig the year. Can't quite figure out why it's not working. The other problem is what happens when the year changes and I am doing 12 months from October? How do I handle that?